DBA Data[Home] [Help]

APPS.PER_PJI_BUS dependencies on PER_PREVIOUS_EMPLOYERS

Line 182: , per_previous_employers pem

178: select pbg.security_group_id
179: from per_business_groups pbg
180: , per_prev_job_extra_info pji
181: , per_previous_jobs pjo
182: , per_previous_employers pem
183: where pji.previous_job_extra_info_id = p_previous_job_extra_info_id
184: and pji.previous_job_id = pjo.previous_job_id
185: and pjo.previous_employer_id = pem.previous_employer_id
186: and pbg.business_group_id = pem.business_group_id;

Line 245: , per_previous_employers pem

241: select pbg.legislation_code
242: from per_business_groups pbg
243: , per_prev_job_extra_info pji
244: , per_previous_jobs pjo
245: , per_previous_employers pem
246: where pji.previous_job_extra_info_id = p_previous_job_extra_info_id
247: and pji.previous_job_id = pjo.previous_job_id
248: and pjo.previous_employer_id = pem.previous_employer_id(+)
249: and pem.business_group_id = pbg.business_group_id(+);