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

4292: oe_debug_pub.add('Create_Item: ' || 'Going to fetch Validation Org ' ,2);
4293: END IF;
4294:
4295:
4296: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
4297: into lValidationOrg from oe_order_lines_all oel
4298: where oel.line_id = pLineId ;
4299:
4300:

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

6342: oe_debug_pub.add('Create_Item: ' || 'Going to fetch Validation Org ' ,2);
6343: END IF;
6344:
6345:
6346: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
6347: into lValidationOrg from oe_order_lines_all oel
6348: where oel.line_id = pLineId ;
6349:
6350: