DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_POPULATION_RANGES

Line 3045: - Uses person_id in pay_population_ranges

3041: );
3042:
3043: /*
3044: Bug 7138494 - Added Cursor for Range Person
3045: - Uses person_id in pay_population_ranges
3046: --------------------------------------------------------------------+
3047: -- Cursor : c_range_asgids
3048: -- Description : Fetches assignments For Recconciling Payment Summary
3049: -- Returns DISTINCT assignment_id

Line 3074: ,pay_population_ranges ppr

3070: from per_people_f pap
3071: ,per_assignments_f paa
3072: ,pay_payroll_actions rppa
3073: ,per_periods_of_service pps
3074: ,pay_population_ranges ppr
3075: where rppa.payroll_action_id = p_payroll_action_id
3076: and rppa.payroll_action_id = ppr.payroll_action_id
3077: AND ppr.payroll_action_id = p_payroll_action_id
3078: and ppr.chunk_number = p_chunk

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

3295:
3296: IF l_assignment_id = '%' THEN -- For multiple Assignments
3297:
3298: /* Bug 7138494 - Added Changes for Range Person
3299: - Call Cursor using pay_population_ranges if Range Person Enabled
3300: Else call Old Cursor
3301: */
3302: IF range_person_on
3303: THEN