APPS.PQP_PENSION_FUNCTIONS dependencies on PAY_INPUT_VALUES_F

Line 4916: pay_input_values_f INPUTV

4912: ,nvl(LIV.default_value,INPUTV.default_value)),'N',EEV.screen_entry_value),NULL)))
4913: FROM pay_element_entry_values_f EEV,
4914: pay_element_entries_f EE,
4915: pay_link_input_values_f LIV,
4916: pay_input_values_f INPUTV
4917: WHERE INPUTV.input_value_id = c_ipv_id
4918: AND c_effective_date BETWEEN INPUTV.effective_start_date
4919: AND INPUTV.effective_end_date
4920: AND INPUTV.element_type_id + 0 = p_element_type_id

Line 4936: from pay_input_values_f_tl iv_tl,

4932: AND nvl(EE.ENTRY_TYPE, 'E') = 'E';
4933:
4934: CURSOR c_iv_id_cur IS
4935: select iv.input_value_id
4936: from pay_input_values_f_tl iv_tl,
4937: pay_input_values_f iv
4938: where iv.element_type_id = p_element_type_id
4939: and iv_tl.input_value_id = iv.input_value_id
4940: and iv_tl.language = userenv('LANG')

Line 4937: pay_input_values_f iv

4933:
4934: CURSOR c_iv_id_cur IS
4935: select iv.input_value_id
4936: from pay_input_values_f_tl iv_tl,
4937: pay_input_values_f iv
4938: where iv.element_type_id = p_element_type_id
4939: and iv_tl.input_value_id = iv.input_value_id
4940: and iv_tl.language = userenv('LANG')
4941: and upper(iv_tl.name) = upper(p_input_value_name)