DBA Data[Home] [Help]

APPS.OZF_OM_VALIDATION_PVT dependencies on OE_SYS_PARAMETERS_ALL

Line 411: select parameter_value from oe_sys_parameters_all

407: l_oe_disc_dtls_on_invoice VARCHAR2(1);
408:
409: --R12 Forward port bug#9498844,This Cursor is used for Getting the OM system Paramter value for the 'OE_DISCOUNT_DETAILS_ON_INVOICE'.
410: CURSOR get_om_profle IS
411: select parameter_value from oe_sys_parameters_all
412: where parameter_code = 'OE_DISCOUNT_DETAILS_ON_INVOICE' and org_id = mo_global.get_current_org_id;
413:
414: CURSOR csr_inv_line_price(cv_customer_trx_line_id IN NUMBER) IS
415: SELECT inventory_item_id