DBA Data[Home] [Help]

APPS.PER_NO_WORK_INCIDENT_API dependencies on PER_ALL_PEOPLE_F

Line 108: from per_all_people_f per

104: l_legislation_code varchar2(2);
105: --
106: cursor csr_get_business_group_id is
107: select per.business_group_id
108: from per_all_people_f per
109: where per.person_id = p_person_id
110: and p_effective_date between per.effective_start_date
111: and per.effective_end_date;
112: --

Line 364: from per_all_people_f per

360: l_legislation_code varchar2(2);
361: --
362: cursor csr_get_business_group_id is
363: select per.business_group_id
364: from per_all_people_f per
365: where per.person_id = (select person_id
366: from per_work_incidents
367: where incident_id = p_incident_id)
368: and p_effective_date between per.effective_start_date