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 441: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)

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