APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PAY_POPULATION_RANGES

Line 198: - Uses person_id in pay_population_ranges

194: group by ppac1.assignment_id);
195:
196: /*
197: Bug 8501365 - Added Cursor for Range Person
198: - Uses person_id in pay_population_ranges
199: --------------------------------------------------------------------+
200: -- Cursor : range_process_assignments
201: -- Description : Fetches assignments For Payment Summary
202: -- Returns DISTINCT assignment_id

Line 217: pay_population_ranges ppr,

213: DISTINCT a.assignment_id,
214: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
215: ppac.assignment_action_id
216: FROM pay_payroll_actions pa,
217: pay_population_ranges ppr,
218: pay_payroll_actions ppa,
219: per_people_f p,
220: per_assignments_f a,
221: pay_assignment_actions ppac

Line 357: ,pay_population_ranges ppr

353: ,pay_payroll_actions ppa
354: ,pay_assignment_actions ppac
355: ,pay_assignment_actions pmaa
356: ,pay_payroll_actions pmpa
357: ,pay_population_ranges ppr
358: WHERE pa.payroll_action_id = c_payroll_action_id
359: AND ppr.payroll_action_id = pa.payroll_action_id
360: AND ppr.chunk_number = c_chunk
361: AND p.person_id = ppr.person_id

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

424:
425: IF l_get_paysum_details.payment_summary_type = 'O'
426: THEN
427: /* Bug 8501365 - Added Changes for Range Person
428: - Call Cursor using pay_population_ranges if Range Person Enabled
429: Else call Old Cursor
430: */
431: IF range_person_on
432: THEN