APPS.PAY_IN_TAX_UTILS dependencies on HR_LOOKUPS

Line 2613: FROM hr_lookups hrl

2609: CURSOR c_ltc_block(p_date DATE)
2610: IS
2611: SELECT hrl.lookup_code
2612: ,hrl.meaning
2613: FROM hr_lookups hrl
2614: WHERE hrl.lookup_type ='IN_LTC_BLOCK'
2615: AND to_number(to_char(p_date,'YYYY')) BETWEEN
2616: to_number(SUBSTR(HRL.LOOKUP_CODE,1,4)) AND to_number(SUBSTR(HRL.LOOKUP_CODE,8,4)) ;
2617:

Line 2727: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;

2723: l_curr_element_entry tab_entry_id;
2724:
2725: l_max_ltc NUMBER;
2726: l_carry_over_entry_count NUMBER;
2727: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
2728: l_curr_period HR_LOOKUPS.meaning%TYPE;
2729: l_curr_end_date DATE;
2730: l_curr_start_date DATE;
2731:

Line 2728: l_curr_period HR_LOOKUPS.meaning%TYPE;

2724:
2725: l_max_ltc NUMBER;
2726: l_carry_over_entry_count NUMBER;
2727: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
2728: l_curr_period HR_LOOKUPS.meaning%TYPE;
2729: l_curr_end_date DATE;
2730: l_curr_start_date DATE;
2731:
2732: l_prev_blk_date DATE;

Line 2733: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;

2729: l_curr_end_date DATE;
2730: l_curr_start_date DATE;
2731:
2732: l_prev_blk_date DATE;
2733: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
2734: l_prev_period HR_LOOKUPS.meaning%TYPE;
2735: l_prev_end_date DATE;
2736: l_prev_start_date DATE;
2737:

Line 2734: l_prev_period HR_LOOKUPS.meaning%TYPE;

2730: l_curr_start_date DATE;
2731:
2732: l_prev_blk_date DATE;
2733: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
2734: l_prev_period HR_LOOKUPS.meaning%TYPE;
2735: l_prev_end_date DATE;
2736: l_prev_start_date DATE;
2737:
2738: