APPS.PAY_GB_PAYROLL_RULES dependencies on PAY_ALL_PAYROLLS_F

Line 32: FROM pay_all_payrolls_f

28: l_span_end DATE;
29: --
30: CURSOR get_current_details IS
31: SELECT soft_coding_keyflex_id, effective_start_date, effective_end_date
32: FROM pay_all_payrolls_f
33: WHERE payroll_id = p_payroll_id
34: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
35: --
36: CURSOR get_next_details IS

Line 38: FROM pay_all_payrolls_f

34: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
35: --
36: CURSOR get_next_details IS
37: SELECT soft_coding_keyflex_id
38: FROM pay_all_payrolls_f
39: WHERE payroll_id = p_payroll_id
40: AND l_cur_eff_end+1 BETWEEN effective_start_date and effective_end_date;
41: --
42: CURSOR get_prev_details IS

Line 44: FROM pay_all_payrolls_f

40: AND l_cur_eff_end+1 BETWEEN effective_start_date and effective_end_date;
41: --
42: CURSOR get_prev_details IS
43: SELECT soft_coding_keyflex_id
44: FROM pay_all_payrolls_f
45: WHERE payroll_id = p_payroll_id
46: AND l_cur_eff_start-1 BETWEEN effective_start_date and effective_end_date;
47: --
48: CURSOR get_paye_ref(p_scl_id NUMBER) IS

Line 55: FROM pay_all_payrolls_f

51: WHERE soft_coding_keyflex_id = p_scl_id;
52: --
53: CURSOR get_min_max_dates IS
54: SELECT min(effective_start_date) first_eff_start, max(effective_end_date)
55: FROM pay_all_payrolls_f
56: WHERE payroll_id = p_payroll_id;
57: --
58: l_found NUMBER;
59: --

Line 437: FROM pay_all_payrolls_f

433: l_span_end DATE;
434: --
435: CURSOR get_current_details IS
436: SELECT soft_coding_keyflex_id, effective_end_date
437: FROM pay_all_payrolls_f
438: WHERE payroll_id = p_payroll_id
439: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
440: --
441: CURSOR get_next_details IS

Line 443: FROM pay_all_payrolls_f

439: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
440: --
441: CURSOR get_next_details IS
442: SELECT effective_end_date
443: FROM pay_all_payrolls_f
444: WHERE payroll_id = p_payroll_id
445: AND l_cur_eff_end+1 BETWEEN effective_start_date and effective_end_date;
446: --
447: CURSOR get_next_to_next_details IS

Line 449: FROM pay_all_payrolls_f

445: AND l_cur_eff_end+1 BETWEEN effective_start_date and effective_end_date;
446: --
447: CURSOR get_next_to_next_details IS
448: SELECT soft_coding_keyflex_id
449: FROM pay_all_payrolls_f
450: WHERE payroll_id = p_payroll_id
451: AND l_next_eff_end+1 BETWEEN effective_start_date and effective_end_date;
452: --
453: CURSOR get_paye_ref(p_scl_id NUMBER) IS

Line 460: FROM pay_all_payrolls_f

456: WHERE soft_coding_keyflex_id = p_scl_id;
457: --
458: CURSOR get_min_max_dates IS
459: SELECT min(effective_start_date) first_eff_start, max(effective_end_date)
460: FROM pay_all_payrolls_f
461: WHERE payroll_id = p_payroll_id;
462: --
463: l_found NUMBER;
464: --