DBA Data[Home] [Help]

APPS.PER_DK_WORK_INCIDENT_API dependencies on PER_ALL_PEOPLE_F

Line 120: from per_all_people_f per

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

Line 400: from per_all_people_f per

396: l_legislation_code varchar2(2);
397: --
398: cursor csr_get_business_group_id is
399: select per.business_group_id
400: from per_all_people_f per
401: where per.person_id = (select person_id
402: from per_work_incidents
403: where incident_id = p_incident_id)
404: and p_effective_date between per.effective_start_date