DBA Data[Home] [Help]

APPS.PER_SA_DISABILITY_API dependencies on PER_ALL_PEOPLE_F

Line 78: from per_all_people_f per

74: l_legislation_code varchar2(2);
75: --
76: cursor csr_get_business_group_id is
77: select per.business_group_id
78: from per_all_people_f per
79: where per.person_id = p_person_id
80: and p_effective_date between per.effective_start_date
81: and per.effective_end_date;
82: --

Line 268: from per_all_people_f per

264: l_legislation_code varchar2(2);
265: --
266: cursor csr_get_business_group_id is
267: select per.business_group_id
268: from per_all_people_f per
269: where per.person_id in (select dis.person_id
270: from per_disabilities_f dis
271: where dis.disability_id = p_disability_id
272: and p_effective_date between dis.effective_start_date