APPS.AR_RECEIPT_LIB_PVT dependencies on DUAL

Line 2267: from dual;

2263: IF (p_receipt_date IS NULL)
2264: THEN
2265: Select trunc(sysdate)
2266: into p_receipt_date
2267: from dual;
2268: END IF;
2269:
2270: -- default the gl_date
2271: IF p_gl_date IS NULL THEN

Line 2936: from dual;

2932: )
2933: )
2934: )
2935: into l_calc_line_per
2936: from dual;
2937:
2938: -- Bug 6931978 Cross Currency App
2939: IF p_invoice_currency_code <> p_receipt_currency_code THEN
2940: IF Nvl(sp_lines_row.amount_applied_from,0) <> 0

Line 3864: FROM dual

3860: rcr.cust_account_id= p_cr_customer_id
3861: and rcr.bill_to_flag = 'Y'
3862: UNION
3863: SELECT p_cr_customer_id
3864: FROM dual
3865: UNION
3866: SELECT rel.related_cust_account_id
3867: FROM ar_paying_relationships_v rel,
3868: hz_cust_accounts acc

Line 4077: FROM dual

4073: and rcr.bill_to_flag = 'Y'
4074: and ot.customer_id = rcr.related_cust_account_id
4075: UNION ALL
4076: SELECT /*+ no_unnest */ 'x'
4077: FROM dual
4078: WHERE ot.customer_id = p_cr_customer_id
4079: UNION ALL
4080: SELECT /*+ no_unnest */ 'x'
4081: FROM ar_paying_relationships_v rel,

Line 7393: from dual;

7389: IF (p_receipt_date IS NULL)
7390: THEN
7391: Select trunc(sysdate)
7392: into p_receipt_date
7393: from dual;
7394: END IF;
7395:
7396: -- default the gl_date
7397: IF p_gl_date IS NULL THEN