APPS.PAY_GB_PAYROLL_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 23: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

19: l_cur_eff_start DATE;
20: l_cur_eff_end DATE;
21: l_first_eff_start DATE;
22: l_last_eff_end DATE;
23: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
24: l_new_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
25: l_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
26: l_prev_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
27: l_span_start DATE;

Line 24: l_new_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

20: l_cur_eff_end DATE;
21: l_first_eff_start DATE;
22: l_last_eff_end DATE;
23: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
24: l_new_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
25: l_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
26: l_prev_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
27: l_span_start DATE;
28: l_span_end DATE;

Line 25: l_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

21: l_first_eff_start DATE;
22: l_last_eff_end DATE;
23: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
24: l_new_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
25: l_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
26: l_prev_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
27: l_span_start DATE;
28: l_span_end DATE;
29: --

Line 26: l_prev_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

22: l_last_eff_end DATE;
23: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
24: l_new_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
25: l_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
26: l_prev_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
27: l_span_start DATE;
28: l_span_end DATE;
29: --
30: CURSOR get_current_details IS

Line 50: FROM hr_soft_coding_keyflex

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
49: SELECT segment1
50: FROM hr_soft_coding_keyflex
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)

Line 430: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

426: l_cur_eff_end DATE;
427: l_next_eff_end DATE;
428: l_first_eff_start DATE;
429: l_last_eff_end DATE;
430: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
431: l_next_to_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
432: l_span_start DATE;
433: l_span_end DATE;
434: --

Line 431: l_next_to_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

427: l_next_eff_end DATE;
428: l_first_eff_start DATE;
429: l_last_eff_end DATE;
430: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
431: l_next_to_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
432: l_span_start DATE;
433: l_span_end DATE;
434: --
435: CURSOR get_current_details IS

Line 455: FROM hr_soft_coding_keyflex

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
454: SELECT segment1
455: FROM hr_soft_coding_keyflex
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)