DBA Data[Home] [Help]

APPS.HR_FULL_SYNC_MESSAGES dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 476: HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(SYSDATE , PPF.PERSON_ID) ,

472: /*Select state ment modified for the employee number
473: not getting displayed for Ex-Employee*/
474: cursor csr_person_data is
475: SELECT DECODE ( ppf.CURRENT_NPW_FLAG , 'Y', NPW_NUMBER,EMPLOYEE_NUMBER ) EMPLOYEE_NUMBER,
476: HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(SYSDATE , PPF.PERSON_ID) ,
477: DATE_OF_BIRTH,
478: TOWN_OF_BIRTH,
479: COUNTRY_OF_BIRTH,
480: DATE_OF_DEATH,