DBA Data[Home] [Help]

APPS.PAY_LIVEARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 741: pay_assignment_actions paa, -- Year End

737: SELECT assignment_action_id ,
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

Line 766: pay_assignment_actions paa,

762: c_start_of_year date, c_end_of_year date )
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