DBA Data[Home] [Help]

APPS.PER_PERUSE1L_XMLP_PKG dependencies on PER_US_HR_UTILITY_PKG

Line 515: ,' ') || G_DELIMITER || PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PER.PERSON_ID)

511: FOR per IN C_AUDIT_REPORT LOOP
512: L_BUFFER := PER.PERSON_ID || G_DELIMITER || PER.LAST_NAME || G_DELIMITER || NVL(PER.FIRST_NAME
513: ,' ') || G_DELIMITER || NVL(PER.EMPLOYEE_NUMBER
514: ,' ') || G_DELIMITER || NVL(PER.SEX
515: ,' ') || G_DELIMITER || PER_US_HR_UTILITY_PKG.DERIVE_ALIEN_ETHNIC_ORIGIN(PER.PERSON_ID)
516: || G_DELIMITER || PER.ASSIGNMENT_ID || G_DELIMITER || NVL(TO_CHAR(PER.JOB_ID)
517: ,' ') || G_DELIMITER || NVL(PER.JOB_NAME
518: ,' ') || G_DELIMITER || NVL(TO_CHAR(PER.LOCATION_ID)
519: ,' ') || G_DELIMITER || NVL(PER.LOCATION_CODE