APPS.ARP_PROCESS_LOCKBOX dependencies on DUAL

Line 3470: from dual;

3466: if det_line.apply_to not in ('FREIGHT','CHARGES') then
3467:
3468: Select ar_activity_details_s.nextval
3469: INTO l_line_id
3470: from dual;
3471:
3472: insert into AR_INTERIM_CASH_LINE_DETAILS(
3473: cash_receipt_id,
3474: customer_trx_line_id,

Line 3605: from dual;

3601: END IF;
3602:
3603: Select ar_activity_details_s.nextval
3604: INTO l_line_id
3605: from dual;
3606:
3607: insert into AR_INTERIM_CASH_LINE_DETAILS(
3608: cash_receipt_id,
3609: customer_trx_line_id,

Line 3822: ' from dual ' ||

3818: ' where ' ||
3819: ' ps.trx_number = :b_current_matching_number ' ||
3820: ' and ps.customer_id in ( select decode(:b_pay_unrelated_customers, ''Y'', ps.customer_id, ' ||
3821: ' nvl(:b_customer_id, ps.customer_id)) ' ||
3822: ' from dual ' ||
3823: ' UNION ' ||
3824: ' select related_cust_account_id ' ||
3825: ' from hz_cust_acct_relate rel ' ||
3826: ' where rel.cust_account_id = :b_customer_id ' ||

Line 3856: ' from dual ' ||

3852: ' ''N'', ''OP'', ps.status) ' || */
3853: ' and ps.customer_id in ( select '||
3854: ' decode(:b_pay_unrelated_customers,''Y'', ps.customer_id, ' ||
3855: ' nvl(:b_customer_id, ps.customer_id)) ' ||
3856: ' from dual ' ||
3857: ' UNION ' ||
3858: ' select related_cust_account_id ' ||
3859: ' from hz_cust_acct_relate rel ' ||
3860: ' where rel.cust_account_id = :b_customer_id ' ||

Line 3954: ' from dual ' ||

3950: ' rctl.sales_order = :b_current_matching_number ' ||
3951: ' and rct.bill_to_customer_id in ( select decode(:b_pay_unrelated_customers, ''Y'', ' ||
3952: ' rct.bill_to_customer_id, ' ||
3953: ' nvl(:b_customer_id, rct.bill_to_customer_id)) ' ||
3954: ' from dual ' ||
3955: ' UNION ' ||
3956: ' select related_cust_account_id ' ||
3957: ' from hz_cust_acct_relate rel ' ||
3958: ' where rel.cust_account_id = :b_customer_id ' ||

Line 4049: ' from dual ' ||

4045: ' rct.purchase_order = :b_current_matching_number ' ||
4046: ' and rct.bill_to_customer_id in ( select decode(:b_pay_unrelated_customers, ''Y'', ' ||
4047: ' rct.bill_to_customer_id, ' ||
4048: ' nvl(:b_customer_id, rct.bill_to_customer_id)) ' ||
4049: ' from dual ' ||
4050: ' UNION ' ||
4051: ' select related_cust_account_id ' ||
4052: ' from hz_cust_acct_relate rel ' ||
4053: ' where rel.cust_account_id = :b_customer_id ' ||

Line 4114: ' from dual ' ||

4110: ' where ' ||
4111: ' ci.cons_billing_number = :b_current_matching_number ' ||
4112: ' and ci.customer_id in ( select decode(:b_pay_unrelated_customers, ''Y'', ci.customer_id, ' ||
4113: ' nvl(:b_customer_id, ci.customer_id)) ' ||
4114: ' from dual ' ||
4115: ' UNION ' ||
4116: ' select related_cust_account_id ' ||
4117: ' from hz_cust_acct_relate rel ' ||
4118: ' where rel.cust_account_id = :b_customer_id ' ||