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: /* Start Bug Fix 7343780 */

Line 463: FROM pay_all_payrolls_f

459: l_span_end DATE;
460: --
461: CURSOR get_current_details IS
462: SELECT soft_coding_keyflex_id, effective_end_date
463: FROM pay_all_payrolls_f
464: WHERE payroll_id = p_payroll_id
465: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
466: --
467: CURSOR get_next_details IS

Line 469: FROM pay_all_payrolls_f

465: AND p_effective_date BETWEEN effective_start_date and effective_end_date;
466: --
467: CURSOR get_next_details IS
468: SELECT effective_end_date
469: FROM pay_all_payrolls_f
470: WHERE payroll_id = p_payroll_id
471: AND l_cur_eff_end+1 BETWEEN effective_start_date and effective_end_date;
472: --
473: CURSOR get_next_to_next_details IS

Line 475: FROM pay_all_payrolls_f

471: AND l_cur_eff_end+1 BETWEEN effective_start_date and effective_end_date;
472: --
473: CURSOR get_next_to_next_details IS
474: SELECT soft_coding_keyflex_id
475: FROM pay_all_payrolls_f
476: WHERE payroll_id = p_payroll_id
477: AND l_next_eff_end+1 BETWEEN effective_start_date and effective_end_date;
478: --
479: CURSOR get_paye_ref(p_scl_id NUMBER) IS

Line 486: FROM pay_all_payrolls_f

482: WHERE soft_coding_keyflex_id = p_scl_id;
483: --
484: CURSOR get_min_max_dates IS
485: SELECT min(effective_start_date) first_eff_start, max(effective_end_date)
486: FROM pay_all_payrolls_f
487: WHERE payroll_id = p_payroll_id;
488: --
489: l_found NUMBER;
490: /* Start Bug Fix 7343780 */