eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DELTA_SYNC_MESSAGES dependencies on PER_ALL_PEOPLE_F

Line 879: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;

875: ,retcode OUT NOCOPY VARCHAR2
876: ,p_party_site_id in NUMBER) is
877:
878:
879: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
880: L_USER_PERSON_TYPE VARCHAR2(60);
881: L_DATE_OF_BIRTH DATE;
882: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
883: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;

Line 882: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;

878:
879: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
880: L_USER_PERSON_TYPE VARCHAR2(60);
881: L_DATE_OF_BIRTH DATE;
882: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
883: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;
884: L_DATE_OF_DEATH DATE;
885: L_ORIGINAL_DATE_OF_HIRE DATE;
886: L_EFFECTIVE_START_DATE DATE;

Line 883: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;

879: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%type;
880: L_USER_PERSON_TYPE VARCHAR2(60);
881: L_DATE_OF_BIRTH DATE;
882: L_TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%type;
883: L_COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%type;
884: L_DATE_OF_DEATH DATE;
885: L_ORIGINAL_DATE_OF_HIRE DATE;
886: L_EFFECTIVE_START_DATE DATE;
887: L_SEX VARCHAR2(30);

Line 889: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;

885: L_ORIGINAL_DATE_OF_HIRE DATE;
886: L_EFFECTIVE_START_DATE DATE;
887: L_SEX VARCHAR2(30);
888: L_MARITAL_STATUS VARCHAR2(30);
889: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
890: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
891: L_SUFFIX VARCHAR2(30);
892: L_TITLE VARCHAR2(30);
893: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;

Line 890: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;

886: L_EFFECTIVE_START_DATE DATE;
887: L_SEX VARCHAR2(30);
888: L_MARITAL_STATUS VARCHAR2(30);
889: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
890: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
891: L_SUFFIX VARCHAR2(30);
892: L_TITLE VARCHAR2(30);
893: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
894: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;

Line 893: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;

889: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%type;
890: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
891: L_SUFFIX VARCHAR2(30);
892: L_TITLE VARCHAR2(30);
893: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
894: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
895: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
896: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
897: L_DATE_FROM DATE;

Line 894: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;

890: L_PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%type;
891: L_SUFFIX VARCHAR2(30);
892: L_TITLE VARCHAR2(30);
893: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
894: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
895: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
896: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
897: L_DATE_FROM DATE;
898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;

Line 895: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;

891: L_SUFFIX VARCHAR2(30);
892: L_TITLE VARCHAR2(30);
893: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
894: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
895: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
896: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
897: L_DATE_FROM DATE;
898: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
899: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

Line 907: L_EMAIL_ADDRESS per_all_people_f.email_address%type;

903: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%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;

Line 911: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%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);
914: p_gen_status varchar2(10);
915: p_event_key_gen varchar2(150);

Line 959: FROM PER_ALL_PEOPLE_F ppf,

955: NATIONAL_IDENTIFIER,
956: ppf.business_group_id,
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 ,

Line 977: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'

973: AND ppn.PARENT_ID (+) = PPF.PERSON_ID
974: -- Modified for the bug 6895752 starts here
975: /*AND ( ppn.parent_id is null
976: OR ( ppn.parent_id is not null
977: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
978: AND PPN.PHONE_TYPE = 'W1' ))*/
979:
980: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
981: AND PPN.PHONE_TYPE (+) = 'W1'

Line 980: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'

976: OR ( ppn.parent_id is not null
977: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
978: AND PPN.PHONE_TYPE = 'W1' ))*/
979:
980: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
981: AND PPN.PHONE_TYPE (+) = 'W1'
982: -- Modified for the bug 6895752 ends here
983: AND ((ppf.CURRENT_EMPLOYEE_FLAG = 'Y'
984: OR ppf.person_id in -- modified for bug6873563

Line 1073: FROM PER_ALL_PEOPLE_F ppf,

1069: NATIONAL_IDENTIFIER,
1070: ppf.business_group_id,
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 ,

Line 1092: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'

1088: AND ppn.PARENT_ID (+) = PPF.PERSON_ID
1089: -- Modified for the bug 6895752 starts here
1090: /*AND ( ppn.parent_id is null
1091: OR ( ppn.parent_id is not null
1092: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
1093: AND PPN.PHONE_TYPE = 'W1' ))*/
1094:
1095: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
1096: AND PPN.PHONE_TYPE (+) = 'W1'

Line 1095: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'

1091: OR ( ppn.parent_id is not null
1092: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
1093: AND PPN.PHONE_TYPE = 'W1' ))*/
1094:
1095: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
1096: AND PPN.PHONE_TYPE (+) = 'W1'
1097: -- Modified for the bug 6895752 ends here
1098: AND ((ppf.CURRENT_EMPLOYEE_FLAG = 'Y'
1099: OR ppf.person_id =

Line 1373: TYPE EMPLIDTYPE IS TABLE OF per_all_people_f.employee_number%type INDEX BY BINARY_INTEGER;

1369: ,p_party_site_id in NUMBER)
1370: is
1371:
1372:
1373: TYPE EMPLIDTYPE IS TABLE OF per_all_people_f.employee_number%type INDEX BY BINARY_INTEGER;
1374: TYPE EMPL_RCDTYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1375: TYPE PROBATION_DTTYPE IS TABLE OF per_all_assignments_f.probation_period%type INDEX BY BINARY_INTEGER;
1376: TYPE ORIG_HIRE_DTTYPE IS TABLE OF per_all_people_f.original_date_of_hire%type INDEX BY BINARY_INTEGER;
1377: TYPE WEFFDTTYPE IS TABLE OF per_all_assignments_f.effective_start_date%type INDEX BY BINARY_INTEGER;

Line 1376: TYPE ORIG_HIRE_DTTYPE IS TABLE OF per_all_people_f.original_date_of_hire%type INDEX BY BINARY_INTEGER;

1372:
1373: TYPE EMPLIDTYPE IS TABLE OF per_all_people_f.employee_number%type INDEX BY BINARY_INTEGER;
1374: TYPE EMPL_RCDTYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1375: TYPE PROBATION_DTTYPE IS TABLE OF per_all_assignments_f.probation_period%type INDEX BY BINARY_INTEGER;
1376: TYPE ORIG_HIRE_DTTYPE IS TABLE OF per_all_people_f.original_date_of_hire%type INDEX BY BINARY_INTEGER;
1377: TYPE WEFFDTTYPE IS TABLE OF per_all_assignments_f.effective_start_date%type INDEX BY BINARY_INTEGER;
1378: TYPE BUSINESS_UNITTYPE IS TABLE OF per_all_assignments_f.organization_id%type INDEX BY BINARY_INTEGER;
1379: TYPE WJOBCODETYPE IS TABLE OF per_all_assignments_f.job_id%type INDEX BY BINARY_INTEGER;
1380: TYPE EMPL_STATUSTYPE IS TABLE OF per_all_assignments_f.assignment_status_type_id%type INDEX BY BINARY_INTEGER;

Line 1519: FROM per_all_people_f ppf,per_all_assignments_f pas,

1515: pas.frequency,pas.grade_id,pas.supervisor_id,pas.EFFECTIVE_START_DATE,
1516: nvl(pas.EFFECTIVE_END_DATE,sysdate) EFFECTIVE_END_DATE,
1517: nvl(psf.step_id,0) Step_id
1518: ,pos.final_process_date,pos.ACCEPTED_TERMINATION_DATE,pas.last_update_date
1519: FROM per_all_people_f ppf,per_all_assignments_f pas,
1520: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf
1521: WHERE pas.primary_flag='Y'
1522: AND pos.person_id=pas.person_id
1523: AND ppf.person_id = pos.person_id

Line 1658: FROM per_all_people_f ppf,per_all_assignments_f pas,

1654: pas.frequency,pas.grade_id,pas.supervisor_id,pas.EFFECTIVE_START_DATE,
1655: nvl(pas.EFFECTIVE_END_DATE,sysdate) EFFECTIVE_END_DATE,
1656: nvl(psf.step_id,0) Step_id
1657: ,pos.final_process_date,pos.ACCEPTED_TERMINATION_DATE,pas.last_update_date
1658: FROM per_all_people_f ppf,per_all_assignments_f pas,
1659: per_periods_of_service pos,PER_SPINAL_POINT_PLACEMENTS_F psf
1660: WHERE pas.primary_flag='Y'
1661: AND pos.person_id=pas.person_id
1662: AND ppf.person_id = pos.person_id