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