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') ||
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')