DBA Data[Home] [Help]

APPS.PQP_GB_OMP_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 414: FROM pay_input_values_f piv

410: ,c_iv_name varchar2) IS
411: SELECT input_value_id
412: ,piv.name
413: ,piv.element_type_id
414: FROM pay_input_values_f piv
415: ,pay_element_types_f pet
416: WHERE element_name = c_ele_name
417: AND piv.element_type_id = pet.element_type_id
418: AND (piv.business_group_id = p_bg_id OR piv.business_group_id IS NULL)

Line 425: FROM pay_input_values_f

421:
422: CURSOR csr_updinput(c_ip_id number
423: ,c_element_type_id number) IS
424: SELECT rowid
425: FROM pay_input_values_f
426: WHERE input_value_id = c_ip_id
427: AND element_type_id = c_element_type_id
428: FOR UPDATE NOWAIT;
429:

Line 464: UPDATE pay_input_values_f

460: --
461: hr_utility.set_location (l_proc_name, 30);
462: --
463:
464: UPDATE pay_input_values_f
465: SET default_value = p_def_value
466: WHERE rowid = csr_updinput_rec.rowid;
467:
468: END LOOP;