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_JP_GENERIC_UPGRADE_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1302: l_date_start per_periods_of_service.date_start%TYPE;

1298: c_proc constant varchar2(61) := c_package || 'upgrade_jp_pre_tax';
1299: --
1300: l_person_id per_all_assignments_f.person_id%TYPE;
1301: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
1302: l_date_start per_periods_of_service.date_start%TYPE;
1303: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1304: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1305: l_employment_category per_all_assignments.employment_category%TYPE;
1306: l_effective_date pay_payroll_actions.effective_date%TYPE;

Line 1303: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;

1299: --
1300: l_person_id per_all_assignments_f.person_id%TYPE;
1301: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
1302: l_date_start per_periods_of_service.date_start%TYPE;
1303: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1304: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1305: l_employment_category per_all_assignments.employment_category%TYPE;
1306: l_effective_date pay_payroll_actions.effective_date%TYPE;
1307: --

Line 1304: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

1300: l_person_id per_all_assignments_f.person_id%TYPE;
1301: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
1302: l_date_start per_periods_of_service.date_start%TYPE;
1303: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
1304: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1305: l_employment_category per_all_assignments.employment_category%TYPE;
1306: l_effective_date pay_payroll_actions.effective_date%TYPE;
1307: --
1308: l_action_info_id1 pay_action_information.action_information_id%TYPE;

Line 1353: per_periods_of_service pds

1349: l_leaving_reason,
1350: l_actual_termination_date,
1351: l_employment_category
1352: from per_all_assignments_f asg,
1353: per_periods_of_service pds
1354: where asg.assignment_id = p_assignment_id
1355: and l_effective_date between asg.effective_start_date and asg.effective_end_date
1356: and pds.period_of_service_id = asg.period_of_service_id;
1357: --