DBA Data[Home] [Help]

APPS.HR_FI_PREVIOUS_EMPLOYMENT_API dependencies on PER_BUSINESS_GROUPS

Line 65: from per_business_groups

61: l_legislation_code varchar2(2);
62: --
63: cursor csr_bg is
64: select legislation_code
65: from per_business_groups
66: where business_group_id in
67: (
68: select business_group_id
69: from per_previous_employers

Line 218: from per_business_groups pbg

214: l_legislation_code varchar2(2);
215: --
216: cursor csr_bg is
217: select legislation_code
218: from per_business_groups pbg
219: where pbg.business_group_id in (select pe.business_group_id
220: from per_previous_jobs pj , per_previous_employers pe
221: where pj.PREVIOUS_EMPLOYER_ID = pe.PREVIOUS_EMPLOYER_ID
222: and pj.PREVIOUS_JOB_ID = p_previous_job_id