DBA Data[Home] [Help]

APPS.PAY_US_941_REPORT dependencies on PER_ASSIGNMENTS_F

Line 254: per_assignments_f paf,

250: NULL,
251: NULL,
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') ||

Line 255: per_assignments_f paf1,

251: NULL,
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')