APPS.HR_DELTA_SYNC_MESSAGES dependencies on PER_PHONES

Line 908: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;

904: L_REGION_1 PER_ADDRESSES.REGION_1%type;
905: L_REGION_2 PER_ADDRESSES.REGION_1%type;
906: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
907: L_EMAIL_ADDRESS per_all_people_f.email_address%type;
908: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
909: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
910: L_NATIONALITY VARCHAR2(30);
911: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
912: l_business_group_id number(15);

Line 909: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;

905: L_REGION_2 PER_ADDRESSES.REGION_1%type;
906: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
907: L_EMAIL_ADDRESS per_all_people_f.email_address%type;
908: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
909: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
910: L_NATIONALITY VARCHAR2(30);
911: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
912: l_business_group_id number(15);
913: p_gen_msg VARCHAR2(4000);

Line 961: PER_PHONES ppn ,

957: ppf.LAST_UPDATE_DATE
958:
959: FROM PER_ALL_PEOPLE_F ppf,
960: PER_ADDRESSES padr ,
961: PER_PHONES ppn ,
962: hr_lookups HL1 ,
963: HR_LOOKUPS HL2 ,
964: HR_LOOKUPS HL3 ,
965: HR_LOOKUPS HL4

Line 1075: PER_PHONES ppn ,

1071: ppf.LAST_UPDATE_DATE
1072:
1073: FROM PER_ALL_PEOPLE_F ppf,
1074: PER_ADDRESSES padr ,
1075: PER_PHONES ppn ,
1076: hr_lookups HL1 ,
1077: HR_LOOKUPS HL2 ,
1078: HR_LOOKUPS HL3 ,
1079: HR_LOOKUPS HL4