APPS.PAY_IN_TAX_UTILS dependencies on HR_LOOKUPS

Line 2178: FROM hr_lookups hrl

2174: CURSOR c_ltc_block(p_date DATE)
2175: IS
2176: SELECT hrl.lookup_code
2177: ,hrl.meaning
2178: FROM hr_lookups hrl
2179: WHERE hrl.lookup_type ='IN_LTC_BLOCK'
2180: AND to_number(to_char(p_date,'YYYY')) BETWEEN
2181: to_number(SUBSTR(HRL.LOOKUP_CODE,1,4)) AND to_number(SUBSTR(HRL.LOOKUP_CODE,8,4)) ;
2182:

Line 2291: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;

2287: l_curr_element_entry tab_entry_id;
2288:
2289: l_max_ltc NUMBER;
2290: l_carry_over_entry_count NUMBER;
2291: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
2292: l_curr_period HR_LOOKUPS.meaning%TYPE;
2293: l_curr_end_date DATE;
2294: l_curr_start_date DATE;
2295:

Line 2292: l_curr_period HR_LOOKUPS.meaning%TYPE;

2288:
2289: l_max_ltc NUMBER;
2290: l_carry_over_entry_count NUMBER;
2291: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
2292: l_curr_period HR_LOOKUPS.meaning%TYPE;
2293: l_curr_end_date DATE;
2294: l_curr_start_date DATE;
2295:
2296: l_prev_blk_date DATE;

Line 2297: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;

2293: l_curr_end_date DATE;
2294: l_curr_start_date DATE;
2295:
2296: l_prev_blk_date DATE;
2297: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
2298: l_prev_period HR_LOOKUPS.meaning%TYPE;
2299: l_prev_end_date DATE;
2300: l_prev_start_date DATE;
2301:

Line 2298: l_prev_period HR_LOOKUPS.meaning%TYPE;

2294: l_curr_start_date DATE;
2295:
2296: l_prev_blk_date DATE;
2297: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
2298: l_prev_period HR_LOOKUPS.meaning%TYPE;
2299: l_prev_end_date DATE;
2300: l_prev_start_date DATE;
2301:
2302: