DBA Data[Home] [Help]

APPS.PER_KW_DISABILITY_API dependencies on PER_ALL_PEOPLE_F

Line 79: from per_all_people_f per

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

Line 271: from per_all_people_f per

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