APPS.PER_PDP_BUS dependencies on PER_ALL_PEOPLE_F

Line 262: from per_all_people_f per

258: order by 1 desc;
259: --
260: cursor csr_get_max_per_eff_date is
261: select max(per.effective_start_date)
262: from per_all_people_f per
263: where per.person_id = p_person_id;
264: --
265: begin
266: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1175: -- c) The person_id must exist in PER_ALL_PEOPLE_F at the effective

1171: -- Description:
1172: -- Validates that the following business rules are met:
1173: -- a) Mandatory (I,U)
1174: -- b) UPDATE not allowed (U)
1175: -- c) The person_id must exist in PER_ALL_PEOPLE_F at the effective
1176: -- date (I)
1177: -- NB: The unique combination of person_id and date_start is validated
1178: -- for uniqueness.
1179: --

Line 1211: from per_all_people_f p

1207: l_person_id number;
1208:
1209: cursor c_get_person is
1210: select p.person_id
1211: from per_all_people_f p
1212: where p.person_id = p_person_id
1213: and p.business_group_id = p_business_group_id
1214: and p_effective_date between
1215: p.effective_start_date and p.effective_end_date;