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 742: per_assignments_f paf

738: serial_number ,
739: tax_unit_id
740: FROM pay_payroll_actions ppa, -- Year End
741: pay_assignment_actions paa, -- Year End
742: per_assignments_f paf
743: WHERE ppa.report_type = 'YREND'
744: AND ppa.action_status = 'C'
745: AND ppa.effective_date = c_end_of_year
746: AND ppa.legislative_parameters like c_gre_id || ' TRANSFER%'

Line 751: FROM per_assignments_f paf2

747: AND ppa.payroll_action_id = paa.payroll_action_id
748: AND paa.action_status = 'C'
749: AND paf.assignment_id = paa.assignment_id
750: AND paf.effective_start_date = ( SELECT max(paf2.effective_start_date)
751: FROM per_assignments_f paf2
752: WHERE paf2.assignment_id = paf.assignment_id
753: AND paf2.effective_start_date <= c_end_of_year )
754: AND paf.effective_end_date >= c_start_of_year;
755:

Line 767: per_assignments_f paf,

763: IS
764: SELECT paa.assignment_action_id
765: FROM
766: pay_assignment_actions paa,
767: per_assignments_f paf,
768: pay_payroll_actions ppa,
769: pay_action_classifications pac
770: WHERE paf.person_id = c_person_id
771: AND paa.assignment_id = paf.assignment_id