APPS.PER_DB_PER_ADDITIONAL dependencies on PER_PEOPLE_F

Line 152: FROM per_people_f pp

148: SELECT 'Y'
149: INTO l_emp_check
150: FROM sys.dual
151: WHERE p_date_start = (SELECT min(effective_start_date)
152: FROM per_people_f pp
153: WHERE pp.person_id = p_person_id
154: AND pp.current_employee_flag = 'Y');
155: --
156: hr_utility.set_location('per_db_per_additional.insert_period_of_service',5);

Line 254: FROM per_people_f pp

250: SELECT 'Y'
251: INTO l_apl_check
252: FROM sys.dual
253: WHERE p_date_received = (SELECT min(effective_start_date)
254: FROM per_people_f pp
255: WHERE pp.person_id = p_person_id
256: AND pp.current_applicant_flag = 'Y');
257: --
258: hr_utility.set_location('per_db_per_additional.insert_application',5);

Line 429: INSERT INTO per_people_f

425: );
426: --
427: hr_utility.set_location('per_db_per_additional.insert_person',7);
428: --
429: INSERT INTO per_people_f
430: (person_id
431: ,effective_start_date
432: ,effective_end_date
433: ,business_group_id

Line 560: FROM per_people_f pp

556: SELECT per_assignments_s.nextval
557: , pp.employee_number
558: INTO l_assignment_id
559: , l_employee_number
560: FROM per_people_f pp
561: WHERE pp.person_id = p_person_id
562: AND p_effective_start_date BETWEEN pp.effective_start_date
563: AND pp.effective_end_date;
564: --

Line 1135: FROM per_people_f

1131: if p_recruiter_id IS NULL then null;
1132: else
1133: SELECT person_id
1134: INTO l_recruiter_id
1135: FROM per_people_f
1136: WHERE (business_group_id = l_business_group_id or
1137: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
1138: AND person_id = p_recruiter_id
1139: AND current_employee_flag = 'Y'

Line 1149: FROM per_people_f

1145: if p_person_referred_by_id IS NULL then null;
1146: else
1147: SELECT person_id
1148: INTO l_person_referred_by_id
1149: FROM per_people_f
1150: WHERE (business_group_id = l_business_group_id or
1151: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
1152: AND person_id = p_person_referred_by_id
1153: AND current_employee_flag = 'Y'

Line 1487: FROM per_people_f

1483: if p_supervisor_id IS NULL then null;
1484: else
1485: SELECT person_id
1486: INTO l_supervisor_id
1487: FROM per_people_f
1488: WHERE (business_group_id = l_business_group_id OR
1489: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1490: AND person_id = p_supervisor_id
1491: AND current_employee_flag = 'Y'

Line 1747: FROM per_people_f pp

1743: --
1744: hr_utility.set_location('per_db_per_additional.create_secondary_assign',3);
1745: SELECT 'Y'
1746: INTO l_type_check
1747: FROM per_people_f pp
1748: WHERE pp.person_id = p_person_id
1749: AND l_effective_start_date BETWEEN pp.effective_start_date
1750: AND pp.effective_end_date
1751: AND ((p_assignment_type = 'E'

Line 1912: FROM per_people_f

1908: if p_supervisor_id IS NULL then null;
1909: else
1910: SELECT person_id
1911: INTO l_supervisor_id
1912: FROM per_people_f
1913: WHERE business_group_id + 0 = l_business_group_id
1914: AND person_id = p_supervisor_id
1915: AND current_employee_flag = 'Y'
1916: AND l_effective_start_date BETWEEN effective_start_date

Line 2087: FROM per_people_f

2083: if p_recruiter_id IS NULL then null;
2084: else
2085: SELECT person_id
2086: INTO l_recruiter_id
2087: FROM per_people_f
2088: WHERE (business_group_id = l_business_group_id or
2089: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
2090: AND person_id = p_recruiter_id
2091: AND current_employee_flag = 'Y'

Line 2101: FROM per_people_f

2097: if p_person_referred_by_id IS NULL then null;
2098: else
2099: SELECT person_id
2100: INTO l_person_referred_by_id
2101: FROM per_people_f
2102: WHERE (business_group_id = l_business_group_id or
2103: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')
2104: AND person_id = p_person_referred_by_id
2105: AND current_employee_flag = 'Y'

Line 2224: , per_people_f pp

2220: hr_utility.set_location('per_db_per_additional.create_contact',2);
2221: SELECT pp.person_id
2222: INTO l_person_id
2223: FROM per_periods_of_service pos
2224: , per_people_f pp
2225: WHERE pp.business_group_id + 0 = l_business_group_id
2226: AND pp.current_employee_flag = 'Y'
2227: AND pp.employee_number = p_employee_number
2228: AND pp.person_id = pos.person_id

Line 2261: FROM per_people_f

2257: else
2258: hr_utility.set_location('per_db_per_additional.create_contact',4);
2259: SELECT DISTINCT person_id
2260: INTO l_contact_person_id
2261: FROM per_people_f
2262: WHERE business_group_id + 0 = l_business_group_id
2263: AND person_id = p_contact_person_id;
2264: end if;
2265: --