APPS.ARP_RECEIPTS_MAIN dependencies on DUAL

Line 588: FROM dual

584:
585: --Force a No data found exception to be raised if call made and no rows to delete
586: SELECT 'x'
587: INTO l_dummy
588: FROM dual
589: WHERE l_dummy = 'Y';
590:
591: IF PG_DEBUG in ('Y', 'C') THEN
592: arp_standard.debug('ARP_RECEIPTS_MAIN.Delete_MCD()-');

Line 2091: | Set counters to indicate dual creation of receivables for CM and |

2087: END IF;
2088:
2089:
2090: /*-------------------------------------------------------------------+
2091: | Set counters to indicate dual creation of receivables for CM and |
2092: | CM and Invoices for CM applications - detail level of granularity |
2093: +-------------------------------------------------------------------*/
2094: IF p_app_rec.application_type = 'CM' THEN
2095: l_j := 2;

Line 2780: END LOOP; --dual call to allocation routine

2776:
2777:
2778: END IF; --application to Bill or Transaction
2779:
2780: END LOOP; --dual call to allocation routine
2781:
2782: ELSE
2783: /*-----------------------------------------------------------------------+
2784: | do not call the Tax accounting to move deferred tax this happens when |

Line 3323: from dual

3319: +------------------------------------------------------------------------------*/
3320: IF NOT l_mcd_exists THEN
3321: select 'x'
3322: into l_dummy
3323: from dual
3324: where 1 = 2;
3325: END IF;
3326:
3327: /*--------------------------------------------------------------------------------------------+