DBA Data[Home] [Help]

APPS.PER_OBJ_BUS dependencies on PER_ALL_PEOPLE_F

Line 285: from per_all_people_f

281: --
282: Cursor csr_person_bg
283: is
284: select business_group_id
285: from per_all_people_f
286: where person_id = p_owning_person_id;
287: --
288: --
289: -- Cursor to check if person is valid

Line 295: from per_all_people_f

291: --
292: Cursor csr_person_valid_date
293: is
294: select 'Y'
295: from per_all_people_f
296: where person_id = p_owning_person_id
297: and p_effective_date between
298: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
299: --