[Home] [Help]
1362:
1363:
1364: /*
1365: Bug 7138494 - Added Cursor for Range Person
1366: - Uses person_id in pay_population_ranges
1367: --------------------------------------------------------------------+
1368: -- Cursor : range_process_assignments
1369: -- Description : Fetches assignments For Recconciling Payment Summary
1370: -- Returns DISTINCT assignment_id
1379: FROM per_people_f p /*Bug3043049*/
1380: ,per_assignments_f a /*Bug3043049*/
1381: ,pay_payroll_actions pa
1382: ,per_periods_of_service pps
1383: ,pay_population_ranges ppr
1384: WHERE pa.payroll_action_id = c_payroll_action_id
1385: AND pa.payroll_action_id = ppr.payroll_action_id
1386: AND ppr.payroll_action_id = c_payroll_action_id
1387: AND ppr.chunk_number = c_chunk
1497: and pbd.legislation_code = pdb.legislation_code;
1498:
1499: /*
1500: Bug 13043341- Added Cursor for Range Person
1501: - Uses person_id in pay_population_ranges
1502: -------------------------------------------------------------------------+
1503: -- Cursor : range_process_assignment_set
1504: -- Description : Fetches assignments For Archival, process assignment set
1505: -- parameter.
1515: FROM per_people_f p
1516: ,per_assignments_f a
1517: ,pay_payroll_actions pa
1518: ,per_periods_of_service pps
1519: ,pay_population_ranges ppr
1520: ,hr_assignment_set_amendments hasa
1521: WHERE pa.payroll_action_id = c_payroll_action_id
1522: AND pa.payroll_action_id = ppr.payroll_action_id
1523: AND ppr.payroll_action_id = c_payroll_action_id
1928: else
1929: /* Multiple Assignments */
1930:
1931: /* Bug 7138494 - Added Changes for Range Person
1932: - Call Cursor using pay_population_ranges if Range Person Enabled
1933: Else call Old Cursor
1934: */
1935:
1936: IF range_person_on