DBA Data[Home] [Help]

APPS.PAY_US_941_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 142: pay_assignment_actions paa, pay_payroll_actions ppa

138: COUNT(DISTINCT paf.person_id)
139: FROM per_time_periods ptp,
140: per_assignments_f paf,
141: per_assignments_f paf1,
142: pay_assignment_actions paa, pay_payroll_actions ppa
143: WHERE ptp.end_date >= TO_DATE('01'||TO_CHAR
144: (TRUNC(to_date(cp_qtr||'-'||cp_year, 'DD-MM-YYYY'), 'Q'),'MM') ||
145: TO_CHAR(to_date(cp_qtr||'-'||cp_year, 'DD-MM-YYYY'),'YYYY'),'DD-MM-YYYY')
146: AND ptp.start_date <= TO_DATE('12'||TO_CHAR