DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_SYS_PARAMETERS_SYN

Line 539: FROM oe_sys_parameters_syn

535: -- Get Customer Acceptance enabled OU
536: -------------------------------------
537: CURSOR ca_enabled_cur IS
538: SELECT count(org_id), org_id
539: FROM oe_sys_parameters_syn
540: WHERE parameter_code = 'ENABLE_FULFILLMENT_ACCEPTANCE'
541: AND nvl(parameter_value,'N') = 'Y'
542: AND ((p_operating_unit IS NULL) OR (org_id = p_operating_unit))
543: GROUP BY org_id