DBA Data[Home] [Help]

APPS.PAY_US_941_REPORT dependencies on PER_TIME_PERIODS

Line 238: INDEX (ptp PER_TIME_PERIODS_N50)

234: SELECT COUNT(DISTINCT person_id) -- #Bug 14181799
235: FROM
236: (
237: SELECT /*+ LEADING(ptp) -- For Bug 4769835
238: INDEX (ptp PER_TIME_PERIODS_N50)
239: USE_NL(ptp ppa)
240: */
241: paf.person_id person_id,
242: paa.assignment_id assignment_id, -- #Bug 14181799

Line 253: FROM per_time_periods ptp,

249: NULL,
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