APPS.CTO_CONFIG_ITEM_PK dependencies on OE_SYS_PARAMETERS

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

291: |
292: | Modified on 26-Mar-2004 By Sushant Sawant
293: | Fixed Bug#3484511
294: | all queries referencing oe_system_parameters_all
295: | should be replaced with a function call to oe_sys_parameters.value
296: |
297: |
298: | Modified on 23-Jun-2006 by Kiran Konada
299: | Revreted bugfix 3473737, branch fix 3463999

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

4197: oe_debug_pub.add('Create_Item: ' || 'Going to fetch Validation Org ' ,2);
4198: END IF;
4199:
4200:
4201: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
4202: into lValidationOrg from oe_order_lines_all oel
4203: where oel.line_id = pLineId ;
4204:
4205:

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

6157: oe_debug_pub.add('Create_Item: ' || 'Going to fetch Validation Org ' ,2);
6158: END IF;
6159:
6160:
6161: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
6162: into lValidationOrg from oe_order_lines_all oel
6163: where oel.line_id = pLineId ;
6164:
6165: