DBA Data[Home] [Help]

APPS.HR_FULL_SYNC_MESSAGES dependencies on HR_PERSON_TYPE_USAGE_INFO

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

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