APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 219: FROM pay_input_values_f

215: --
216: CURSOR csr_ipv (c_ele_typeid NUMBER
217: ,c_effective_date DATE) IS
218: SELECT input_value_id
219: FROM pay_input_values_f
220: WHERE element_type_id = c_ele_typeid
221: AND business_group_id = p_business_group_id
222: AND NAME = 'Pay Value'
223: AND c_effective_date BETWEEN effective_start_date

Line 638: update pay_input_values_f

634:
635: hr_utility.set_location('Entering : '||l_proc_name, 10);
636:
637: --
638: update pay_input_values_f
639: set mandatory_flag = c_mandatory_flag
640: where element_type_id =c_element_type_id
641: and name = c_iv_name
642: and business_group_id = c_business_group_id;