PJC_PAY_ELEMENT_TYPES_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
ELEMENT_TYPE_ID ELEMENT_NAME BASE_ELEMENT_NAME LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE LEGISLATIVE_DATA_GROUP_NAME

Query

SQL_Statement

SELECT PAYELEMENT.ELEMENT_TYPE_ID, PAYELEMENT.ELEMENT_NAME, PAYELEMENT.BASE_ELEMENT_NAME, PAYELEMENT.LEGISLATIVE_DATA_GROUP_ID, PAYELEMENT.LEGISLATION_CODE, LDG.NAME LEGISLATIVE_DATA_GROUP_NAME FROM PAY_ELEMENT_TYPES_VL PAYELEMENT , PER_LEGISLATIVE_DATA_GROUPS_VL LDG WHERE PAYELEMENT.LEGISLATIVE_DATA_GROUP_ID = LDG.LEGISLATIVE_DATA_GROUP_ID(+) GROUP BY PAYELEMENT.ELEMENT_TYPE_ID, PAYELEMENT.ELEMENT_NAME, PAYELEMENT.BASE_ELEMENT_NAME, PAYELEMENT.LEGISLATIVE_DATA_GROUP_ID, PAYELEMENT.LEGISLATION_CODE, LDG.NAME