DBA Data[Home] [Help]

APPS.HR_AE_CONTRACT_API dependencies on PER_ALL_PEOPLE_F

Line 70: FROM per_all_people_f per

66: l_legislation_code VARCHAR2(2);
67: --
68: CURSOR csr_get_business_group_id IS
69: SELECT per.business_group_id
70: FROM per_all_people_f per
71: WHERE per.person_id = p_person_id
72: and p_effective_DATE between per.effective_start_DATE
73: and per.effective_END_DATE;
74: --

Line 260: FROM per_all_people_f per

256: l_legislation_code VARCHAR2(2);
257: --
258: CURSOR csr_get_business_group_id IS
259: SELECT per.business_group_id
260: FROM per_all_people_f per
261: WHERE per.person_id = p_person_id
262: AND p_effective_DATE BETWEEN per.effective_start_DATE
263: AND per.effective_END_DATE;
264: --