APPS.OE_PRICING_CONT_PVT dependencies on OE_ORDER_HEADERS

Line 3011: from oe_order_headers

3007: /*
3008: oe_debug_pub.add('Geresh In Check Order Header' || p_Agreement_id);
3009: SELECT agreement_id into
3010: l_agreement_id
3011: from oe_order_headers
3012: where agreement_id = p_Agreement_id;
3013:
3014:
3015: oe_debug_pub.add('Geresh In Check Order Header After sql' || sql%rowcount);

Line 3024: not exists (select 1 from oe_order_headers

3020: end if;
3021: */
3022: --Added following code for Bug 2321498
3023: Select 'N' into l_exist from dual where
3024: not exists (select 1 from oe_order_headers
3025: where agreement_id = p_Agreement_id);
3026: oe_debug_pub.add('Geresh In Check Order Header After sql');
3027: oe_debug_pub.add('l_exist :'||l_exist);
3028: