DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on DUAL

Line 3560: from dual;

3556: -- set up 'tangible' record:
3557:
3558: select 'ARI_'||ar_payment_server_ord_num_s.nextval
3559: into l_payment_server_order_num
3560: from dual;
3561:
3562: l_tangible_rec.tangible_id := l_payment_server_order_num;
3563: l_tangible_rec.tangible_amount := rct_info.amount;
3564: l_tangible_rec.currency_code := rct_info.currency_code;

Line 11597: FROM dual;

11593: --fetch request_id ,all the receipts to be created in the batch will be associated
11594: -- to this request
11595: SELECT FND_CONCURRENT_REQUESTS_S.nextval
11596: INTO l_request_id
11597: FROM dual;
11598:
11599: IF NVL(p_fetch_bulk_commit,0) > 0 THEN
11600: l_bulk_count := p_fetch_bulk_commit ;
11601: ELSE

Line 12048: FROM dual

12044: AND cust_acct.cust_account_id = l_customer_id
12045: AND cust_acct.cust_account_id in
12046: (
12047: SELECT TO_NUMBER(l_rec_customer_id)
12048: FROM dual
12049: UNION
12050: SELECT related_cust_account_id
12051: FROM hz_cust_acct_relate r
12052: WHERE r.cust_account_id = l_rec_customer_id