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.PAY_FR_DADS_EMP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 84: , per_periods_of_service pps

80: , fnd_territories_tl ft_tl
81: , fnd_territories ft1
82: , fnd_territories_tl ft1_tl
83: , hr_organization_information org_est
84: , per_periods_of_service pps
85: Where paa.assignment_action_id = g_assign_action_id
86: And paf.assignment_id = paa.assignment_id
87: And paf.establishment_id = org_est.organization_id
88: And org_est.org_information1 = p_org_id

Line 1076: From per_periods_of_service pps

1072: Select pps.Date_start start_date
1073: ,pps.Actual_termination_date term_date
1074: ,pps.Final_process_date final_date
1075: ,pps.Leaving_reason leav_reason
1076: From per_periods_of_service pps
1077: ,per_all_assignments_f asg
1078: ,hr_organization_information org_est
1079: ,pay_assignment_actions paa
1080: Where paa.assignment_action_id = g_assign_action_id

Line 1258: l_leav_reason per_periods_of_service.leaving_reason%type;

1254: l_job_definition_id number;
1255: l_job_name per_jobs.name%type;
1256: l_pcs_code VARCHAR2(50);
1257: l_eff_job_date DATE;
1258: l_leav_reason per_periods_of_service.leaving_reason%type;
1259:
1260: l_percentage_part_time NUMBER;
1261: l_emp_month_hours NUMBER;
1262: l_estab_monthly_hours NUMBER;