APPS.PAY_AU_PAYMENT_SUMMARY_MAGTAPE dependencies on PAY_POPULATION_RANGES

Line 155: pay_population_ranges ppr

151: paa.assignment_action_id ps_report_id,
152: paa.assignment_id
153: FROM pay_assignment_actions paa,
154: per_assignments_f a,
155: pay_population_ranges ppr
156: WHERE paa.payroll_action_id = c_payroll_action_id
157: AND ppr.payroll_action_id = p_payroll_action_id
158: AND ppr.chunk_number = c_chunk
159: AND paa.action_status = 'C'

Line 226: - Uses person_id in pay_population_ranges

222:
223:
224: /*
225: Bug 8501365 - Added Cursor for Range Person
226: - Uses person_id in pay_population_ranges
227: --------------------------------------------------------------------+
228: -- Cursor : range_process_assignments
229: -- Description : Fetches assignments For Data File
230: -- Used when RANGE_PERSON_ID feature is enabled

Line 238: INDEX (ppr PAY_POPULATION_RANGES_N4)

234: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
235: c_chunk IN NUMBER)
236: IS
237: SELECT /*+ INDEX (mpa PAY_PAYROLL_ACTIONS_PK)
238: INDEX (ppr PAY_POPULATION_RANGES_N4)
239: INDEX (p PER_PEOPLE_F_PK)
240: INDEX (apa PAY_PAYROLL_ACTIONS_N52)
241: INDEX (a PER_ASSIGNMENTS_F_N12)
242: INDEX (apac PAY_ASSIGNMENT_ACTIONS_N51)

Line 250: pay_population_ranges ppr,

246: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
247: ppac.assignment_action_id ps_report_id,
248: ppac.assignment_id
249: FROM pay_payroll_actions mpa,
250: pay_population_ranges ppr,
251: per_people_f p,
252: per_assignments_f a,
253: pay_payroll_actions apa,
254: pay_assignment_actions apac,

Line 331: pay_population_ranges ppr

327: paa.assignment_action_id ps_report_id,
328: paa.assignment_id
329: FROM pay_assignment_actions paa,
330: per_assignments_f a,
331: pay_population_ranges ppr
332: WHERE paa.payroll_action_id = c_payroll_action_id
333: AND ppr.payroll_action_id = p_payroll_action_id
334: AND ppr.chunk_number = c_chunk
335: AND paa.action_status = 'C'

Line 421: pay_population_ranges ppr

417: pay_assignment_actions apac,
418: pay_payroll_actions ppa,
419: pay_assignment_actions ppac,
420: pay_action_interlocks ppai,
421: pay_population_ranges ppr
422: WHERE mpa.payroll_action_id =c_payroll_action_id
423: AND ppr.payroll_action_id = mpa.payroll_action_id
424: AND ppr.chunk_number = c_chunk
425: AND p.person_id = a.person_id

Line 563: - Call Cursor using pay_population_ranges if Range Person Enabled

559: ELSE -- In this case fetch the assignments locked by Self-Printed Process.
560: IF l_payment_summary_type = 'O' THEN
561:
562: /* Bug 8501365 - Added Changes for Range Person
563: - Call Cursor using pay_population_ranges if Range Person Enabled
564: Else call Old Cursor
565: */
566: IF range_person_on
567: THEN