DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_COLLECTIVE_AGREEMENTS

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

366: and enabled_flag = 'Y')
367: HOURLY_SALARIED_DESC
368: , CONTRACT_ID
369: , COLLECTIVE_AGREEMENT_ID
370: , (SELECT NAME FROM PER_COLLECTIVE_AGREEMENTS PCA WHERE PCA.COLLECTIVE_AGREEMENT_ID = PAAF.COLLECTIVE_AGREEMENT_ID) COLLECTIVE_AGREEMENT_DESC
371: , CAGR_ID_FLEX_NUM
372: , CAGR_GRADE_DEF_ID
373: , ESTABLISHMENT_ID
374: , (SELECT NAME FROM HR_ESTABLISHMENTS_V HEV WHERE HEV.ESTABLISHMENT_ID = PAAF.ESTABLISHMENT_ID) ESTABLISHMENT_DESC