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

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

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

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

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

5509: oe_debug_pub.add('CTOUTILB.split_line: ' || 'Going to fetch Validation Org ' ,2);
5510: END IF;
5511:
5512:
5513: select nvl( oe_sys_parameters.value( 'MASTER_ORGANIZATION_ID' , oel.org_id) , -99)
5514: into v_organization_id from oe_order_lines_all oel
5515: where oel.line_id = p_ato_line_id;
5516:
5517: