DBA Data[Home] [Help]

APPS.HR_NO_CONTRACT_API dependencies on PER_ALL_PEOPLE_F

Line 71: from per_all_people_f per

67: l_legislation_code varchar2(2);
68: --
69: cursor csr_get_business_group_id is
70: select per.business_group_id
71: from per_all_people_f per
72: where per.person_id = p_person_id
73: and p_effective_date between per.effective_start_date
74: and per.effective_end_date;
75: --

Line 248: from per_all_people_f per

244: l_legislation_code varchar2(2);
245: --
246: cursor csr_get_business_group_id is
247: select per.business_group_id
248: from per_all_people_f per
249: where per.person_id = p_person_id
250: and p_effective_date between per.effective_start_date
251: and per.effective_end_date;
252: --