APPS.OE_PRICING_CONT_PVT dependencies on DUAL

Line 2974: Select 'N' into l_exist from dual where

2970: else
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);

Line 3023: Select 'N' into l_exist from dual where

3019: RETURN TRUE;
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);