APPS.ARP_PROCESS_LOCKBOX dependencies on DUAL

Line 3489: from dual;

3485: if det_line.apply_to not in ('FREIGHT','CHARGES') then
3486:
3487: Select ar_activity_details_s.nextval
3488: INTO l_line_id
3489: from dual;
3490:
3491: insert into AR_INTERIM_CASH_LINE_DETAILS(
3492: cash_receipt_id,
3493: customer_trx_line_id,

Line 3624: from dual;

3620: END IF;
3621:
3622: Select ar_activity_details_s.nextval
3623: INTO l_line_id
3624: from dual;
3625:
3626: insert into AR_INTERIM_CASH_LINE_DETAILS(
3627: cash_receipt_id,
3628: customer_trx_line_id,

Line 3857: ' and EXISTS ( select ''Exists dual'' from dual ' ||

3853: matching condition instead of just the min(ps_id). */
3854: g_cursor_string := g_cursor_string ||
3855: ' where ' ||
3856: ' ps.trx_number = :b_current_matching_number ' ||
3857: ' and EXISTS ( select ''Exists dual'' from dual ' ||
3858: ' where decode(:b_pay_unrelated_customers, ''Y'', ps.customer_id, ' ||
3859: ' nvl(:b_customer_id, ps.customer_id)) = ps.customer_id ' ||
3860: ' UNION ' ||
3861: ' select ''Exists ha_cust_acct_relate'' ' ||

Line 3907: ' and EXISTS ( select ''Exists dual'' from dual ' ||

3903: ' and ps.status = decode(tt.allow_overapplication_flag,' ||
3904: ' ''N'', ''OP'', ps.status) ';
3905: END IF;
3906: g_cursor_string := g_cursor_string ||
3907: ' and EXISTS ( select ''Exists dual'' from dual ' ||
3908: ' where decode(:b_pay_unrelated_customers, ''Y'', ps.customer_id, ' ||
3909: ' nvl(:b_customer_id, ps.customer_id)) = ps.customer_id ' ||
3910: ' UNION ' ||
3911: ' select ''Exists ha_cust_acct_relate'' ' ||

Line 4030: ' and EXISTS ( select ''Exists dual'' from dual ' ||

4026: -- Constructing where clause
4027: g_cursor_string := g_cursor_string ||
4028: ' where ' ||
4029: ' rctl.sales_order = :b_current_matching_number ' ||
4030: ' and EXISTS ( select ''Exists dual'' from dual ' ||
4031: ' where decode(:b_pay_unrelated_customers, ''Y'', rct.bill_to_customer_id, ' ||
4032: ' nvl(:b_customer_id, rct.bill_to_customer_id)) = rct.bill_to_customer_id ' ||
4033: ' UNION ' ||
4034: ' select ''Exists ha_cust_acct_relate'' ' ||

Line 4145: ' and EXISTS ( select ''Exists dual'' from dual ' ||

4141: -- Constructing WHERE clause
4142: g_cursor_string := g_cursor_string ||
4143: ' where ' ||
4144: ' rct.purchase_order = :b_current_matching_number ' ||
4145: ' and EXISTS ( select ''Exists dual'' from dual ' ||
4146: ' where decode(:b_pay_unrelated_customers, ''Y'', rct.bill_to_customer_id, ' ||
4147: ' nvl(:b_customer_id, rct.bill_to_customer_id)) = rct.bill_to_customer_id ' ||
4148: ' UNION ' ||
4149: ' select ''Exists ha_cust_acct_relate'' ' ||

Line 4214: ' and EXISTS ( select ''Exists dual'' from dual ' ||

4210: -- Constructing WHERE clause
4211: g_cursor_string := g_cursor_string ||
4212: ' where ' ||
4213: ' ci.cons_billing_number = :b_current_matching_number ' ||
4214: ' and EXISTS ( select ''Exists dual'' from dual ' ||
4215: ' where decode(:b_pay_unrelated_customers, ''Y'', ci.customer_id, ' ||
4216: ' nvl(:b_customer_id, ci.customer_id)) = ci.customer_id ' ||
4217: ' UNION ' ||
4218: ' select ''Exists ha_cust_acct_relate'' ' ||