DBA Data[Home] [Help]

APPS.PER_KW_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 363: from per_all_people_f per

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