[Home] [Help]
1299: IS
1300: CURSOR csr_first_name IS
1301: SELECT substr(papf.first_name||' '||papf.middle_names,1,20)
1302: FROM per_people_f papf,
1303: per_assignments_f paf,
1304: pay_assignment_actions paa,
1305: pay_payroll_actions ppa
1306: WHERE paa.assignment_action_id = p_run_assignment_action_id
1307: AND paf.assignment_id = paa.assignment_id
1338: IS
1339: CURSOR csr_last_name is
1340: SELECT substr(papf.last_name,1,20)
1341: FROM per_people_f papf,
1342: per_assignments_f paf,
1343: pay_assignment_actions paa,
1344: pay_payroll_actions ppa
1345: WHERE paa.assignment_action_id = p_run_assignment_action_id
1346: AND paf.assignment_id = paa.assignment_id
1378: -- Used per_all_assignments_f 4555600
1379: CURSOR csr_dob IS
1380: SELECT to_char(papf.date_of_birth,'dd-mon-yyyy')
1381: FROM per_people_f papf,
1382: per_assignments_f paf,
1383: pay_assignment_actions paa,
1384: pay_payroll_actions ppa
1385: WHERE paa.assignment_action_id = p_run_assignment_action_id
1386: AND paf.assignment_id = paa.assignment_id
2352: -- Used per_all_assignments_f 4555600
2353: hr_utility.trace('Range Cursor Not using Payroll Restriction');
2354: sqlstr := 'SELECT distinct asg.person_id
2355: FROM per_periods_of_service pos,
2356: per_assignments_f asg,
2357: pay_payroll_actions ppa
2358: WHERE ppa.payroll_action_id = :payroll_action_id
2359: AND pos.person_id = asg.person_id
2360: AND pos.period_of_service_id = asg.period_of_service_id
2368: hr_utility.trace('Range Cursor using Payroll Restriction');
2369: sqlstr := 'SELECT DISTINCT ppf.person_id
2370: FROM per_people_f ppf,
2371: pay_payroll_actions ppa,
2372: per_assignments_f paaf
2373: WHERE ppa.payroll_action_id = :payroll_action_id
2374: AND ppf.business_group_id +0 = ppa.business_group_id
2375: AND paaf.person_id = ppf.person_id
2376: AND paaf.payroll_id = '|| to_char(l_payroll_id) ||
2457: pay_payroll_actions appa2,
2458: pay_assignment_actions act,
2459: pay_assignment_actions act1,
2460: pay_action_interlocks pai,
2461: per_assignments_f as1
2462: WHERE ppa.payroll_action_id = p_pact_id
2463: AND appa.consolidation_set_id = p_consolidation_id
2464: AND appa.effective_date BETWEEN
2465: ppa.start_date AND ppa.effective_date
2508: pay_payroll_actions appa2,
2509: pay_assignment_actions act,
2510: pay_assignment_actions act1,
2511: pay_action_interlocks pai,
2512: per_assignments_f as1,
2513: pay_population_ranges ppr
2514: WHERE ppa.payroll_action_id = p_pact_id
2515: AND appa.consolidation_set_id = p_consolidation_id
2516: AND appa.effective_date BETWEEN