APPS.ARP_LOCKBOX_HOOK_PVT dependencies on DUAL

Line 919: select l_customer_id from dual

915: ps.status)
916: AND ps.class NOT IN ('PMT','GUAR')
917: AND (ps.customer_id IN
918: (
919: select l_customer_id from dual
920: union
921: select related_cust_account_id
922: from hz_cust_acct_relate rel
923: where rel.cust_account_id = l_customer_id

Line 1029: FROM dual;

1025: IF l_error_flag = 'T' THEN
1026:
1027: SELECT ar_payments_interface_s.nextval
1028: INTO l_transmission_rec_id_of
1029: FROM dual;
1030:
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_util.debug('Validation failed for '||l_unres_inv_array(i).matching_number);
1033: END IF;

Line 1097: FROM dual;

1093: FOR j in 1..l_res_invoice_index LOOP
1094:
1095: SELECT ar_payments_interface_s.nextval
1096: INTO l_transmission_rec_id_of
1097: FROM dual;
1098:
1099: /* Insert a new overflow record for the new invoice number resolved. */
1100: INSERT INTO ar_payments_interface_all(
1101: transmission_record_id,