DBA Data[Home] [Help]

APPS.HR_KW_CONTRACT_API dependencies on PER_ALL_PEOPLE_F

Line 72: from per_all_people_f per

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

Line 251: from per_all_people_f per

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