APPS.PER_IN_PERQUISITE_PKG dependencies on HR_LOOKUPS

Line 856: FROM hr_lookups hrl

852: CURSOR c_ltc_block(p_date DATE)
853: IS
854: SELECT hrl.lookup_code
855: ,hrl.meaning
856: FROM hr_lookups hrl
857: WHERE hrl.lookup_type ='IN_LTC_BLOCK'
858: AND to_number(to_char(p_date,'YYYY')) BETWEEN
859: to_number(SUBSTR(HRL.LOOKUP_CODE,1,4)) AND to_number(SUBSTR(HRL.LOOKUP_CODE,8,4)) ;
860:

Line 927: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;

923:
924: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
925:
926:
927: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
928: l_curr_period HR_LOOKUPS.meaning%TYPE;
929: l_current_year NUMBER;
930: l_current_blk_start NUMBER;
931:

Line 928: l_curr_period HR_LOOKUPS.meaning%TYPE;

924: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
925:
926:
927: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
928: l_curr_period HR_LOOKUPS.meaning%TYPE;
929: l_current_year NUMBER;
930: l_current_blk_start NUMBER;
931:
932: l_prev_blk_date DATE;

Line 933: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;

929: l_current_year NUMBER;
930: l_current_blk_start NUMBER;
931:
932: l_prev_blk_date DATE;
933: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
934: l_prev_period HR_LOOKUPS.meaning%TYPE;
935:
936: l_carry_over_id NUMBER;
937: l_journey_block_id NUMBER;

Line 934: l_prev_period HR_LOOKUPS.meaning%TYPE;

930: l_current_blk_start NUMBER;
931:
932: l_prev_blk_date DATE;
933: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
934: l_prev_period HR_LOOKUPS.meaning%TYPE;
935:
936: l_carry_over_id NUMBER;
937: l_journey_block_id NUMBER;
938: