APPS.PQP_UK_VEHICLE_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 158: FROM pay_input_values_f piv,

154: CURSOR c1_delinput(lc_sub_type Varchar2,lc_name varchar2) IS
155: SELECT input_value_id,
156: piv.name,
157: piv.element_type_id
158: FROM pay_input_values_f piv,
159: pay_element_types_f pet
160: WHERE element_name= p_ele_name||' '||lc_sub_type
161: AND piv.element_type_id=pet.element_type_id
162: AND (piv.business_group_id =p_bg_id OR piv.business_group_id IS NULL)

Line 358: FROM pay_input_values_f piv,

354: CURSOR c_get_inputval is
355: SELECT input_value_id,
356: piv.name,
357: piv.element_type_id
358: FROM pay_input_values_f piv,
359: pay_element_types_f pet
360: WHERE piv.element_type_id =p_ele_type
361: AND piv.element_type_id = pet.element_type_id
362: AND piv.business_group_id = p_bg_id

Line 394: UPDATE pay_input_values_f

390: OPEN c_get_inputval ;
391: FETCH c_get_inputval INTO c1_rec;
392: CLOSE c_get_inputval;
393:
394: UPDATE pay_input_values_f
395: SET value_set_id=c3_rec.flex_value_set_id,
396: warning_or_error='W'
397: WHERE input_value_id=c1_rec.input_value_id
398: AND element_type_id=p_ele_type;

Line 411: UPDATE pay_input_values_f

407: LOOP
408: FETCH c_get_id INTO c2_rec;
409: EXIT WHEN c_get_id %NOTFOUND;
410:
411: UPDATE pay_input_values_f
412: SET formula_id=c2_rec.formula_id,
413: warning_or_error='E'
414: WHERE input_value_id=c1_rec.input_value_id
415: AND element_type_id=p_ele_type;