DBA Data[Home] [Help]

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 1172: -- c) The person_id must exist in PER_ALL_PEOPLE_F at the effective

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

Line 1208: from per_all_people_f p

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