APPS.CTO_UTILITY_PK dependencies on OE_SYS_PARAMETERS

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

141: |
142: | Modified on 26-Mar-2004 By Sushant Sawant
143: | Fixed Bug#3484511
144: | all queries referencing oe_system_parameters_all
145: | should be replaced with a function call to oe_sys_parameters.value
146: |
147: |
148: | modified on 17-May-2004 Kiran Konada
149: |

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

1230: oe_debug_pub.add('populate_plan_level: ' || 'Going to fetch Validation Org ' ,2);
1231: END IF;
1232:
1233:
1234: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
1235: into lValidationOrg from oe_order_lines_all oel
1236: where oel.line_id = pLineId ;
1237:
1238:

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

2246: oe_debug_pub.add('populate_bcol: ' || 'Going to fetch Validation Org ' ,2);
2247: END IF;
2248:
2249:
2250: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
2251: into v_organization_id from oe_order_lines_all oel
2252: where oel.line_id = p_bcol_line_id;
2253:
2254:

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

5533: oe_debug_pub.add('CTOUTILB.split_line: ' || 'Going to fetch Validation Org ' ,2);
5534: END IF;
5535:
5536:
5537: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
5538: into v_organization_id from oe_order_lines_all oel
5539: where oel.line_id = p_ato_line_id;
5540:
5541: