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_LIVEARCHIVE_PKG dependencies on PER_ASSIGNMENTS_F

Line 831: per_assignments_f paf

827: serial_number ,
828: tax_unit_id
829: FROM pay_payroll_actions ppa, -- Year End
830: pay_assignment_actions paa, -- Year End
831: per_assignments_f paf
832: WHERE ppa.report_type = 'YREND'
833: AND ppa.action_status = 'C'
834: AND ppa.effective_date = c_end_of_year
835: AND ppa.legislative_parameters like c_gre_id || ' TRANSFER%'

Line 840: FROM per_assignments_f paf2

836: AND ppa.payroll_action_id = paa.payroll_action_id
837: AND paa.action_status = 'C'
838: AND paf.assignment_id = paa.assignment_id
839: AND paf.effective_start_date = ( SELECT max(paf2.effective_start_date)
840: FROM per_assignments_f paf2
841: WHERE paf2.assignment_id = paf.assignment_id
842: AND paf2.effective_start_date <= c_end_of_year )
843: AND paf.effective_end_date >= c_start_of_year;
844:

Line 856: per_assignments_f paf,

852: IS
853: SELECT paa.assignment_action_id
854: FROM
855: pay_assignment_actions paa,
856: per_assignments_f paf,
857: pay_payroll_actions ppa,
858: pay_action_classifications pac
859: WHERE paf.person_id = c_person_id
860: AND paa.assignment_id = paf.assignment_id