DBA Data[Home] [Help]

APPS.HR_USER_INIT_DEDN dependencies on HR_LOOKUPS

Line 1117: FROM hr_lookups

1113: -- Find row code
1114: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',55);
1115: SELECT lookup_code
1116: INTO v_row_code
1117: FROM hr_lookups
1118: WHERE UPPER(meaning) = UPPER(p_paytab_row_type)
1119: AND lookup_type = 'US_TABLE_ROW_TYPES';
1120: --
1121: -- Set SCL:

Line 2225: hr_lookups hl

2221: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',140);
2222: SELECT inp.input_value_id
2223: INTO v_eerefund_payval_id
2224: FROM pay_input_values_f inp,
2225: hr_lookups hl
2226: WHERE inp.element_type_id = p_eerefund_eletype_id
2227: AND inp.name = hl.meaning
2228: AND hl.lookup_code = 'PAY VALUE'
2229: AND hl.lookup_type = 'NAME_TRANSLATIONS';