APPS.PQP_GB_UNPAID_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 320: FROM pay_input_values_f piv

316: IS
317: SELECT input_value_id
318: ,piv.name
319: ,piv.element_type_id
320: FROM pay_input_values_f piv
321: ,pay_element_types_f pet
322: WHERE element_name = c_ele_name
323: AND piv.element_type_id = pet.element_type_id
324: AND (piv.business_group_id = p_bg_id OR piv.business_group_id IS NULL)

Line 332: FROM pay_input_values_f

328: CURSOR csr_updinput(c_ip_id number
329: ,c_element_type_id number)
330: IS
331: SELECT rowid
332: FROM pay_input_values_f
333: WHERE input_value_id = c_ip_id
334: AND element_type_id = c_element_type_id
335: FOR UPDATE NOWAIT;
336:

Line 381: UPDATE pay_input_values_f

377: END IF;
378:
379: --
380:
381: UPDATE pay_input_values_f
382: SET default_value = p_def_value
383: WHERE rowid = csr_updinput_rec.rowid;
384:
385: END LOOP;