DBA Data[Home] [Help]

APPS.HR_SE_WORK_INCIDENT_API dependencies on PER_ALL_PEOPLE_F

Line 126: from per_all_people_f per

122: l_legislation_code varchar2(2);
123: --
124: cursor csr_get_business_group_id is
125: select per.business_group_id
126: from per_all_people_f per
127: where per.person_id = p_person_id
128: and p_effective_date between per.effective_start_date
129: and per.effective_end_date;
130: --

Line 417: from per_all_people_f per

413: l_legislation_code varchar2(2);
414: --
415: cursor csr_get_business_group_id is
416: select per.business_group_id
417: from per_all_people_f per
418: where per.person_id = (select person_id
419: from per_work_incidents
420: where incident_id = p_incident_id)
421: and p_effective_date between per.effective_start_date