APPS.PQP_GB_PENSIONS_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 90: l_name pay_input_values_f.name%TYPE;

86: l_element_type_id NUMBER;
87: l_avcren VARCHAR2(80);
88: l_ele_obj_ver_number NUMBER; --
89: l_ele_name pay_element_types_f.element_name%TYPE;
90: l_name pay_input_values_f.name%TYPE;
91: i NUMBER;
92:
93: -- Extra Information variables
94: l_eei_information2 pay_element_type_extra_info.eei_information2%TYPE;

Line 253: FROM pay_input_values_f piv,

249: CURSOR c1_getinput(lc_ele_name Varchar2,lc_name varchar2) IS
250: SELECT input_value_id,
251: piv.name,
252: piv.element_type_id
253: FROM pay_input_values_f piv,
254: pay_element_types_f pet
255: WHERE element_name= lc_ele_name
256: AND piv.element_type_id=pet.element_type_id
257: AND (piv.business_group_id =p_bg_id OR piv.business_group_id IS NULL)

Line 264: FROM pay_input_values_f

260:
261: CURSOR c2_updinput(lc_ip_id number
262: ,lc_element_type_id number) IS
263: SELECT rowid
264: FROM pay_input_values_f
265: WHERE input_value_id = lc_ip_id
266: AND element_type_id = lc_element_type_id
267: FOR UPDATE NOWAIT;
268:

Line 288: UPDATE pay_input_values_f

284:
285: FETCH c2_updinput INTO c2_rec;
286: EXIT WHEN c2_updinput%NOTFOUND;
287:
288: UPDATE pay_input_values_f
289: SET default_value = l_value
290: WHERE rowid = c2_rec.rowid;
291:
292: END LOOP;