eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PL_PREVIOUS_EMPLOYMENT_API dependencies on PER_PREVIOUS_EMPLOYERS

Line 336: from per_previous_employers pe

332: cursor csr_bg is
333: select legislation_code
334: from per_business_groups pbg
335: where pbg.business_group_id in (select pe.business_group_id
336: from per_previous_employers pe
337: where pe.PREVIOUS_EMPLOYER_ID = p_previous_employer_id
338: );
339:
340: l_period_years number;

Line 562: in (select BUSINESS_GROUP_ID from PER_PREVIOUS_EMPLOYERS where PREVIOUS_EMPLOYER_ID =

558: cursor csr_bg is
559: select legislation_code
560: from per_business_groups pbg
561: where pbg.business_group_id
562: in (select BUSINESS_GROUP_ID from PER_PREVIOUS_EMPLOYERS where PREVIOUS_EMPLOYER_ID =
563: p_previous_employer_id);
564: l_period_years number;
565: l_period_months number;
566: l_period_days number;

Line 781: pjb,PER_PREVIOUS_EMPLOYERS_V pem

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:
785: l_period_years number;