APPS.PER_DB_PER_ADDITIONAL dependencies on HR_LOCATIONS_ALL

Line 90: hr_locations_all. This is done because

86: work.
87: 115.13 29-MAY-01 A.Sahay PTU Changes
88: 115.13 19-JUN-01 GPERRY Performance fixes for WWBUG 1833930.
89: Changed references from hr_locations to
90: hr_locations_all. This is done because
91: of the join using location_code which
92: is consistent with hr_locations_all and
93: not hz_locations.
94: 115.14 06-JUL-01 PBODLA Bug 1877018 - Passed final_process_date

Line 92: is consistent with hr_locations_all and

88: 115.13 19-JUN-01 GPERRY Performance fixes for WWBUG 1833930.
89: Changed references from hr_locations to
90: hr_locations_all. This is done because
91: of the join using location_code which
92: is consistent with hr_locations_all and
93: not hz_locations.
94: 115.14 06-JUL-01 PBODLA Bug 1877018 - Passed final_process_date
95: while calling ben_pps_trg.ler_chk
96: to detect potential life events.

Line 986: -- WWBUG 1833930, changed hr_locations to hr_locations_all

982:
983: --
984: hr_utility.set_location('per_db_per_additional.create_applicant',12);
985: --
986: -- WWBUG 1833930, changed hr_locations to hr_locations_all
987: --
988: if p_vacancy IS NULL then
989: --
990: if p_location IS NULL then null;

Line 995: FROM hr_locations_all

991: else
992: hr_utility.set_location('per_db_per_additional.create_applicant',14);
993: SELECT location_id
994: INTO l_location_id
995: FROM hr_locations_all
996: WHERE location_code = p_location
997: AND l_effective_start_date <= nvl(inactive_date,to_date('4712/12/31',
998: 'YYYY/MM/DD'));
999: end if;

Line 1386: -- WWBUG 1833930, changed hr_locations to hr_locations_all

1382: --
1383: hr_utility.set_location('per_db_per_additional.create_employee',12);
1384: -- Validate position before using
1385: --
1386: -- WWBUG 1833930, changed hr_locations to hr_locations_all
1387: --
1388: if p_location IS NULL then null;
1389: else
1390: hr_utility.set_location('per_db_per_additional.create_employee',14);

Line 1393: FROM hr_locations_all

1389: else
1390: hr_utility.set_location('per_db_per_additional.create_employee',14);
1391: SELECT location_id
1392: INTO l_location_id
1393: FROM hr_locations_all
1394: WHERE location_code = p_location
1395: AND l_effective_start_date <= nvl(inactive_date,to_date('4712/12/31',
1396: 'YYYY/MM/DD'));
1397: end if;

Line 1809: -- WWBUG 1833930, changed hr_locations to hr_locations_all

1805: --
1806: hr_utility.set_location('per_db_per_additional.create_secondary_assign',9);
1807: -- Validate position before using
1808: --
1809: -- WWBUG 1833930, changed hr_locations to hr_locations_all
1810: --
1811: if p_location IS NULL then null;
1812: else
1813: hr_utility.set_location('per_db_per_additional.create_secondary_assign',11);

Line 1816: FROM hr_locations_all

1812: else
1813: hr_utility.set_location('per_db_per_additional.create_secondary_assign',11);
1814: SELECT location_id
1815: INTO l_location_id
1816: FROM hr_locations_all
1817: WHERE location_code = p_location
1818: AND l_effective_start_date <= nvl(inactive_date,to_date('4712/12/31',
1819: 'YYYY/MM/DD'));
1820: end if;

Line 1948: -- WWBUG 1833930, changed hr_locations to hr_locations_all

1944: --
1945: else -- if p_assignment_type = 'A'
1946: hr_utility.set_location('per_db_per_additional.create_secondary_assign',41);
1947: --
1948: -- WWBUG 1833930, changed hr_locations to hr_locations_all
1949: --
1950: if p_vacancy IS NULL then
1951: --
1952: if p_location IS NULL then null;

Line 1957: FROM hr_locations_all

1953: else
1954: hr_utility.set_location('per_db_per_additional.create_secondary_assign',43);
1955: SELECT location_id
1956: INTO l_location_id
1957: FROM hr_locations_all
1958: WHERE location_code = p_location
1959: AND l_effective_start_date <= nvl(inactive_date,to_date('4712/12/31',
1960: 'YYYY/MM/DD'));
1961: end if;