DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_COLLECTIVE_AGREEMENTS

Line 389: , (SELECT NAME FROM PER_COLLECTIVE_AGREEMENTS PCA WHERE PCA.COLLECTIVE_AGREEMENT_ID = PAAF.COLLECTIVE_AGREEMENT_ID) COLLECTIVE_AGREEMENT_DESC

385: and enabled_flag = 'Y')
386: HOURLY_SALARIED_DESC
387: , CONTRACT_ID
388: , COLLECTIVE_AGREEMENT_ID
389: , (SELECT NAME FROM PER_COLLECTIVE_AGREEMENTS PCA WHERE PCA.COLLECTIVE_AGREEMENT_ID = PAAF.COLLECTIVE_AGREEMENT_ID) COLLECTIVE_AGREEMENT_DESC
390: , CAGR_ID_FLEX_NUM
391: , CAGR_GRADE_DEF_ID
392: , ESTABLISHMENT_ID
393: , (SELECT NAME FROM HR_ESTABLISHMENTS_V HEV WHERE HEV.ESTABLISHMENT_ID = PAAF.ESTABLISHMENT_ID) ESTABLISHMENT_DESC