DBA Data[Home] [Help]

APPS.PER_SA_WORK_INCIDENT_API dependencies on PER_ALL_PEOPLE_F

Line 118: from per_all_people_f per

114: l_legislation_code varchar2(2);
115: --
116: cursor csr_get_business_group_id is
117: select per.business_group_id
118: from per_all_people_f per
119: where per.person_id = p_person_id
120: and p_effective_date between per.effective_start_date
121: and per.effective_end_date;
122: --

Line 393: from per_all_people_f per

389: l_legislation_code varchar2(2);
390: --
391: cursor csr_get_business_group_id is
392: select per.business_group_id
393: from per_all_people_f per
394: where per.person_id = (select person_id
395: from per_work_incidents
396: where incident_id = p_incident_id)
397: and p_effective_date between per.effective_start_date