APPS.OE_PRICING_CONT_PVT dependencies on OE_ORDER_LINES

Line 2963: from oe_order_lines

2959: /*
2960: oe_debug_pub.add('Geresh In Check Order Header' || p_Agreement_id);
2961: SELECT agreement_id into
2962: l_agreement_id
2963: from oe_order_lines
2964: where agreement_id = p_Agreement_id;
2965:
2966:
2967: oe_debug_pub.add('Geresh In Check Order Header After sql' || sql%rowcount);

Line 2975: not exists (select 1 from oe_order_lines

2971: RETURN TRUE;
2972: end if; */
2973:
2974: Select 'N' into l_exist from dual where
2975: not exists (select 1 from oe_order_lines
2976: where agreement_id = p_Agreement_id);
2977: oe_debug_pub.add('Geresh In Check Order Line After sql');
2978: oe_debug_pub.add('l_exist :'||l_exist);
2979: