DBA Data[Home] [Help]

APPS.PAY_US_941_REPORT dependencies on PER_ASSIGNMENTS_F

Line 140: per_assignments_f paf,

136: USE_NL(ptp ppa)
137: */
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') ||

Line 141: per_assignments_f paf1,

137: */
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')