APPS.AR_INVOICE_UTILS dependencies on DUAL

Line 485: FROM DUAL

481: AND cr.status = 'A'
482: AND cr.bill_to_flag ='Y'
483: UNION
484: SELECT to_number(gt.bill_to_customer_id)
485: FROM DUAL
486: UNION
487: SELECT acc.cust_account_id
488: FROM ar_paying_relationships_v rel, hz_cust_accounts acc
489: WHERE rel.party_id = acc.party_id

Line 2455: --from dual

2451: and cr.status = 'A'
2452: and cr.bill_to_flag ='Y'
2453: --union
2454: --select to_number(gt.bill_to_customer_id)
2455: --from dual
2456: UNION
2457: SELECT acc.cust_account_id
2458: FROM ar_paying_relationships_v rel,
2459: hz_cust_accounts acc

Line 2642: from dual

2638: and cr.status = 'A'
2639: and cr.bill_to_flag='Y'
2640: union
2641: select to_number(gt.bill_to_customer_id)
2642: from dual
2643: union
2644: select -1 /* no customer case */ from dual )
2645: and gt.trx_date between
2646: nvl( trunc( a.start_date_active ), gt.trx_date )

Line 2644: select -1 /* no customer case */ from dual )

2640: union
2641: select to_number(gt.bill_to_customer_id)
2642: from dual
2643: union
2644: select -1 /* no customer case */ from dual )
2645: and gt.trx_date between
2646: nvl( trunc( a.start_date_active ), gt.trx_date )
2647: and nvl( trunc( a.end_date_active ), gt.trx_date )
2648: and gt.agreement_id = a.agreement_id);

Line 5086: '_s.nextval trx_number from dual';

5082:
5083: l_trx_str := 'select ra_trx_number_' ||
5084: REPLACE(ctrxHeaderRec.batch_source_id, '-', 'N') ||
5085: l_org_str||
5086: '_s.nextval trx_number from dual';
5087:
5088: IF pg_debug = 'Y'
5089: THEN
5090: debug ('Sql String l_trx_str ' || l_trx_str );