APPS.AR_INVOICE_UTILS dependencies on DUAL

Line 492: FROM DUAL

488: AND cr.status = 'A'
489: AND cr.bill_to_flag ='Y'
490: UNION
491: SELECT to_number(gt.bill_to_customer_id)
492: FROM DUAL
493: UNION
494: SELECT acc.cust_account_id
495: FROM ar_paying_relationships_v rel, hz_cust_accounts acc
496: WHERE rel.party_id = acc.party_id

Line 2532: --from dual

2528: and cr.status = 'A'
2529: and cr.bill_to_flag ='Y'
2530: --union
2531: --select to_number(gt.bill_to_customer_id)
2532: --from dual
2533: UNION
2534: SELECT acc.cust_account_id
2535: FROM ar_paying_relationships_v rel,
2536: hz_cust_accounts acc

Line 2719: from dual

2715: and cr.status = 'A'
2716: and cr.bill_to_flag='Y'
2717: union
2718: select to_number(gt.bill_to_customer_id)
2719: from dual
2720: union
2721: select -1 /* no customer case */ from dual )
2722: and gt.trx_date between
2723: nvl( trunc( a.start_date_active ), gt.trx_date )

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

2717: union
2718: select to_number(gt.bill_to_customer_id)
2719: from dual
2720: union
2721: select -1 /* no customer case */ from dual )
2722: and gt.trx_date between
2723: nvl( trunc( a.start_date_active ), gt.trx_date )
2724: and nvl( trunc( a.end_date_active ), gt.trx_date )
2725: and gt.agreement_id = a.agreement_id);

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

5209:
5210: l_trx_str := 'select ra_trx_number_' ||
5211: REPLACE(ctrxHeaderRec.batch_source_id, '-', 'N') ||
5212: l_org_str||
5213: '_s.nextval trx_number from dual';
5214:
5215: IF pg_debug = 'Y'
5216: THEN
5217: debug ('Sql String l_trx_str ' || l_trx_str );