APPS.HR_PL_PREVIOUS_EMPLOYMENT_API dependencies on PER_PREVIOUS_JOBS_V
Line 780: where pbg.business_group_id in (select BUSINESS_GROUP_ID from PER_PREVIOUS_JOBS_V
776: --
777: cursor csr_bg is
778: select legislation_code
779: from per_business_groups pbg 780: where pbg.business_group_id in (select BUSINESS_GROUP_ID from PER_PREVIOUS_JOBS_V 781: pjb,PER_PREVIOUS_EMPLOYERS_V pem
782: where pjb.PREVIOUS_EMPLOYER_ID=pem.PREVIOUS_EMPLOYER_ID
783: and pjb.PREVIOUS_JOB_ID = p_previous_job_id);
784: