APPS.CTO_CONFIG_ROUTING_PK dependencies on OE_SYS_PARAMETERS

Line 111: | should be replaced with a function call to oe_sys_parameters.value

107: |
108: | Modified on 26-Mar-2004 By Sushant Sawant
109: | Fixed Bug#3484511
110: | all queries referencing oe_system_parameters_all
111: | should be replaced with a function call to oe_sys_parameters.value
112: |
113: | Renga Kannan 28-Jan-2004 Front Port bug fix 4049807
114: | Descriptive Flexfield Attribute
115: | category is not copied from model

Line 445: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)

441: oe_debug_pub.add('create_routing_ml: ' || 'Going to fetch Validation Org ' ,2);
442: END IF;
443:
444:
445: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
446: into lOEValidationOrg from oe_order_lines_all oel
447: where oel.line_id = pLineId ;
448:
449: