DBA Data[Home] [Help]

APPS.PAY_US_941_REPORT dependencies on PER_TIME_PERIODS

Line 135: INDEX (ptp PER_TIME_PERIODS_N50)

131: CURSOR c_count_asg_processed(cp_tax_unit_id IN number,
132: cp_qtr IN VARCHAR2,
133: cp_year IN VARCHAR2) IS
134: SELECT /*+ LEADING(ptp) -- For Bug 4769835
135: INDEX (ptp PER_TIME_PERIODS_N50)
136: USE_NL(ptp ppa)
137: */
138: COUNT(DISTINCT paf.person_id)
139: FROM per_time_periods ptp,

Line 139: FROM per_time_periods ptp,

135: INDEX (ptp PER_TIME_PERIODS_N50)
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