APPS.AR_RECEIPT_LIB_PVT dependencies on DUAL

Line 2260: from dual;

2256: IF (p_receipt_date IS NULL)
2257: THEN
2258: Select trunc(sysdate)
2259: into p_receipt_date
2260: from dual;
2261: END IF;
2262:
2263: -- default the gl_date
2264: IF p_gl_date IS NULL THEN

Line 2833: from dual;

2829: )
2830: )
2831: )
2832: into l_calc_line_per
2833: from dual;
2834:
2835: -- Bug 6931978 Cross Currency App
2836: IF p_invoice_currency_code <> p_receipt_currency_code THEN
2837: IF Nvl(sp_lines_row.amount_applied_from,0) <> 0

Line 3679: FROM dual

3675: rcr.cust_account_id= p_cr_customer_id
3676: and rcr.bill_to_flag = 'Y'
3677: UNION
3678: SELECT p_cr_customer_id
3679: FROM dual
3680: UNION
3681: SELECT rel.related_cust_account_id
3682: FROM ar_paying_relationships_v rel,
3683: hz_cust_accounts acc

Line 3854: FROM dual

3850: rcr.cust_account_id= p_cr_customer_id
3851: and rcr.bill_to_flag = 'Y'
3852: UNION
3853: SELECT p_cr_customer_id
3854: FROM dual
3855: UNION
3856: SELECT rel.related_cust_account_id
3857: FROM ar_paying_relationships_v rel,
3858: hz_cust_accounts acc

Line 7104: from dual;

7100: IF (p_receipt_date IS NULL)
7101: THEN
7102: Select trunc(sysdate)
7103: into p_receipt_date
7104: from dual;
7105: END IF;
7106:
7107: -- default the gl_date
7108: IF p_gl_date IS NULL THEN