APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 923: -- HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(P_SYNC_DATE , PPF.PERSON_ID) , bug 6891949

919: not getting displayed for Ex-Employee*/
920: cursor csr_person_delta_sync (P_SYNC_DATE DATE) is
921:
922: SELECT DECODE ( ppf.CURRENT_NPW_FLAG , 'Y',NPW_NUMBER,EMPLOYEE_NUMBER ) EMPLOYEE_NUMBER,
923: -- HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(P_SYNC_DATE , PPF.PERSON_ID) , bug 6891949
924: HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(ppf.last_update_date , PPF.PERSON_ID) ,
925: DATE_OF_BIRTH,
926: TOWN_OF_BIRTH,
927: COUNTRY_OF_BIRTH,

Line 924: HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(ppf.last_update_date , PPF.PERSON_ID) ,

920: cursor csr_person_delta_sync (P_SYNC_DATE DATE) is
921:
922: SELECT DECODE ( ppf.CURRENT_NPW_FLAG , 'Y',NPW_NUMBER,EMPLOYEE_NUMBER ) EMPLOYEE_NUMBER,
923: -- HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(P_SYNC_DATE , PPF.PERSON_ID) , bug 6891949
924: HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(ppf.last_update_date , PPF.PERSON_ID) ,
925: DATE_OF_BIRTH,
926: TOWN_OF_BIRTH,
927: COUNTRY_OF_BIRTH,
928: DATE_OF_DEATH,

Line 1038: HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(sysdate , PPF.PERSON_ID) ,

1034: p_business_group_id1 number(15);
1035: cursor csr_person_delta_qsync (p_employee_number varchar2,p_business_group_id number) is
1036:
1037: SELECT DECODE ( ppf.CURRENT_NPW_FLAG , 'Y',NPW_NUMBER,EMPLOYEE_NUMBER ) EMPLOYEE_NUMBER,
1038: HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(sysdate , PPF.PERSON_ID) ,
1039: DATE_OF_BIRTH,
1040: TOWN_OF_BIRTH,
1041: COUNTRY_OF_BIRTH,
1042: DATE_OF_DEATH,