APPS.PAY_US_941_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 256: pay_assignment_actions paa, pay_payroll_actions ppa

252: 'TRUE') val
253: FROM per_time_periods ptp,
254: per_assignments_f paf,
255: per_assignments_f paf1,
256: pay_assignment_actions paa, pay_payroll_actions ppa
257: WHERE ptp.end_date >= TO_DATE('01'||TO_CHAR
258: (TRUNC(to_date(cp_qtr||'-'||cp_year, 'DD-MM-YYYY'), 'Q'),'MM') ||
259: TO_CHAR(to_date(cp_qtr||'-'||cp_year, 'DD-MM-YYYY'),'YYYY'),'DD-MM-YYYY')
260: AND ptp.start_date <= TO_DATE('12'||TO_CHAR

Line 294: pay_assignment_actions paa,

290: cp_year IN VARCHAR2) IS
291: SELECT COUNT(DISTINCT pps.person_id)
292: FROM per_periods_of_service pps,
293: per_all_assignments_f paaf,
294: pay_assignment_actions paa,
295: pay_payroll_actions ppa,
296: pay_us_emp_fed_tax_rules_f ftr
297: WHERE pps.date_start BETWEEN TO_DATE('04-02-2010','DD-MM-YYYY') AND TO_DATE(cp_qtr||'-'||cp_year,'DD-MM-YYYY')
298: AND paaf.person_id = pps.person_id

Line 309: pay_assignment_actions paa1

305: AND ppa.action_status = 'C'
306: AND ppa.effective_date BETWEEN TRUNC(TO_DATE(cp_qtr||'-'||cp_year,'DD-MM-YYYY'),'Q') AND TO_DATE(cp_qtr||'-'||cp_year,'DD-MM-YYYY')
307: AND NOT EXISTS (SELECT 'Y'
308: FROM pay_payroll_actions ppa1,
309: pay_assignment_actions paa1
310: WHERE paa1.assignment_id = ftr.assignment_id
311: AND ppa1.payroll_action_id = paa1.payroll_action_id
312: AND ppa1.action_type in ('H','M','B')
313: AND ppa1.action_status = 'C'

Line 327: pay_assignment_actions paa,

323: cp_year IN VARCHAR2) IS
324: SELECT COUNT(DISTINCT pps.person_id)
325: FROM per_periods_of_service pps,
326: per_all_assignments_f paaf,
327: pay_assignment_actions paa,
328: pay_payroll_actions ppa,
329: pay_us_emp_fed_tax_rules_f ftr
330: WHERE pps.date_start BETWEEN TO_DATE('04-02-2010','DD-MM-YYYY') AND TO_DATE(cp_qtr||'-'||cp_year,'DD-MM-YYYY')
331: AND paaf.person_id = pps.person_id