DBA Data[Home] [Help]

APPS.PAY_LIVEARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 830: pay_assignment_actions paa, -- Year End

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

Line 855: pay_assignment_actions paa,

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