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

Line 385: ,p_act_term_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE)

381: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
382: ,p_start_date IN DATE
383: ,p_end_date IN DATE
384: ,p_fw_type IN VARCHAR2
385: ,p_act_term_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE)
386: RETURN VARCHAR2
387: AS
388:
389: CURSOR is_fw_terminated

Line 399: ,per_periods_of_service pps

395: IS
396: SELECT pps.actual_termination_date
397: FROM per_assignments_f paf
398: ,hr_soft_coding_keyflex hsc
399: ,per_periods_of_service pps
400: WHERE paf.assignment_id = c_assignment_id
401: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
402: AND hsc.segment1 LIKE c_tax_unit_id
403: AND paf.period_of_service_id = pps.period_of_service_id