APPS.PQP_PENSION_FUNCTIONS dependencies on PAY_INPUT_VALUES_F

Line 4819: pay_input_values_f INPUTV

4815: ,nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),NULL)))
4816: FROM pay_element_entry_values_f EEV,
4817: pay_element_entries_f EE,
4818: pay_link_input_values_f LIV,
4819: pay_input_values_f INPUTV
4820: WHERE INPUTV.input_value_id = c_ipv_id
4821: AND c_effective_date BETWEEN INPUTV.effective_start_date
4822: AND INPUTV.effective_end_date
4823: AND INPUTV.element_type_id + 0 = p_element_type_id

Line 4839: from pay_input_values_f_tl iv_tl,

4835: AND nvl(EE.ENTRY_TYPE, 'E') = 'E';
4836:
4837: CURSOR c_iv_id_cur IS
4838: select iv.input_value_id
4839: from pay_input_values_f_tl iv_tl,
4840: pay_input_values_f iv
4841: where iv.element_type_id = p_element_type_id
4842: and iv_tl.input_value_id = iv.input_value_id
4843: and iv_tl.language = userenv('LANG')

Line 4840: pay_input_values_f iv

4836:
4837: CURSOR c_iv_id_cur IS
4838: select iv.input_value_id
4839: from pay_input_values_f_tl iv_tl,
4840: pay_input_values_f iv
4841: where iv.element_type_id = p_element_type_id
4842: and iv_tl.input_value_id = iv.input_value_id
4843: and iv_tl.language = userenv('LANG')
4844: and upper(iv_tl.name) = upper(p_input_value_name)