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 456: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

452: l_cur_eff_end DATE;
453: l_next_eff_end DATE;
454: l_first_eff_start DATE;
455: l_last_eff_end DATE;
456: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
457: l_next_to_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
458: l_span_start DATE;
459: l_span_end DATE;
460: --

Line 457: l_next_to_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

453: l_next_eff_end DATE;
454: l_first_eff_start DATE;
455: l_last_eff_end DATE;
456: l_cur_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
457: l_next_to_next_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
458: l_span_start DATE;
459: l_span_end DATE;
460: --
461: CURSOR get_current_details IS

Line 481: FROM hr_soft_coding_keyflex

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
480: SELECT segment1
481: FROM hr_soft_coding_keyflex
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)