DBA Data[Home] [Help]

APPS.HR_USER_INIT_DEDN dependencies on HR_LOOKUPS

Line 1105: FROM hr_lookups

1101: -- Find row code
1102: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',55);
1103: SELECT lookup_code
1104: INTO v_row_code
1105: FROM hr_lookups
1106: WHERE UPPER(meaning) = UPPER(p_paytab_row_type)
1107: AND lookup_type = 'US_TABLE_ROW_TYPES';
1108: --
1109: -- Set SCL:

Line 2213: hr_lookups hl

2209: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',140);
2210: SELECT inp.input_value_id
2211: INTO v_eerefund_payval_id
2212: FROM pay_input_values_f inp,
2213: hr_lookups hl
2214: WHERE inp.element_type_id = p_eerefund_eletype_id
2215: AND inp.name = hl.meaning
2216: AND hl.lookup_code = 'PAY VALUE'
2217: AND hl.lookup_type = 'NAME_TRANSLATIONS';