DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_POPULATION_RANGES

Line 940: - Uses person_id in pay_population_ranges

936: AND rppa.effective_date between paaf.effective_start_date AND paaf.effective_end_date);
937:
938: /*
939: Bug 7138494 - Added Cursor for Range Person
940: - Uses person_id in pay_population_ranges
941: --------------------------------------------------------------------+
942: -- Cursor : csr_range_assignment_paysum
943: -- Description : Fetches assignments For Recconciling Payment Summary
944: -- Returns DISTINCT assignment_id

Line 971: ,pay_population_ranges ppr

967: from per_people_f pap
968: ,per_assignments_f paa
969: ,pay_payroll_actions rppa
970: ,per_periods_of_service pps
971: ,pay_population_ranges ppr
972: WHERE rppa.payroll_action_id = c_payroll_action_id
973: AND rppa.payroll_action_id = ppr.payroll_action_id
974: and ppr.payroll_action_id = c_payroll_action_id
975: AND ppr.chunk_number = c_chunk

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

1162: END LOOP;
1163: ELSE
1164:
1165: /* Bug 7138494 - Added Changes for Range Person
1166: - Call Cursor using pay_population_ranges if Range Person Enabled
1167: Else call Old Cursor
1168: */
1169:
1170: IF range_person_on(g_parameters.report_mode)