DBA Data[Home] [Help]

APPS.HR_FI_PREVIOUS_EMPLOYMENT_API dependencies on PER_PREVIOUS_EMPLOYERS

Line 69: from per_previous_employers

65: from per_business_groups
66: where business_group_id in
67: (
68: select business_group_id
69: from per_previous_employers
70: where previous_employer_id = p_previous_employer_id
71: );
72: --
73: begin

Line 220: from per_previous_jobs pj , per_previous_employers pe

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
223: );
224: --