APPS.PER_IN_PERQUISITE_PKG dependencies on HR_LOOKUPS

Line 868: FROM hr_lookups hrl

864: CURSOR c_ltc_block(p_date DATE)
865: IS
866: SELECT hrl.lookup_code
867: ,hrl.meaning
868: FROM hr_lookups hrl
869: WHERE hrl.lookup_type ='IN_LTC_BLOCK'
870: AND to_number(to_char(p_date,'YYYY')) BETWEEN
871: to_number(SUBSTR(HRL.LOOKUP_CODE,1,4)) AND to_number(SUBSTR(HRL.LOOKUP_CODE,8,4)) ;
872:

Line 939: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;

935:
936: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
937:
938:
939: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
940: l_curr_period HR_LOOKUPS.meaning%TYPE;
941: l_current_year NUMBER;
942: l_current_blk_start NUMBER;
943:

Line 940: l_curr_period HR_LOOKUPS.meaning%TYPE;

936: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
937:
938:
939: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
940: l_curr_period HR_LOOKUPS.meaning%TYPE;
941: l_current_year NUMBER;
942: l_current_blk_start NUMBER;
943:
944: l_prev_blk_date DATE;

Line 945: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;

941: l_current_year NUMBER;
942: l_current_blk_start NUMBER;
943:
944: l_prev_blk_date DATE;
945: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
946: l_prev_period HR_LOOKUPS.meaning%TYPE;
947:
948: l_carry_over_id NUMBER;
949: l_journey_block_id NUMBER;

Line 946: l_prev_period HR_LOOKUPS.meaning%TYPE;

942: l_current_blk_start NUMBER;
943:
944: l_prev_blk_date DATE;
945: l_prev_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
946: l_prev_period HR_LOOKUPS.meaning%TYPE;
947:
948: l_carry_over_id NUMBER;
949: l_journey_block_id NUMBER;
950: