APPS.ARP_LOCKBOX_HOOK_PVT dependencies on DUAL

Line 892: select l_customer_id from dual

888: ps.status)
889: AND ps.class NOT IN ('PMT','GUAR')
890: AND (ps.customer_id IN
891: (
892: select l_customer_id from dual
893: union
894: select related_cust_account_id
895: from hz_cust_acct_relate rel
896: where rel.cust_account_id = l_customer_id

Line 986: FROM dual;

982: IF l_error_flag = 'T' THEN
983:
984: SELECT ar_payments_interface_s.nextval
985: INTO l_transmission_rec_id_of
986: FROM dual;
987:
988: arp_util.debug('Validation failed for '||l_unres_inv_array(i).matching_number);
989:
990: /* The Exchange rate info provided at the matching number level does not match

Line 1052: FROM dual;

1048: FOR j in 1..l_res_invoice_index LOOP
1049:
1050: SELECT ar_payments_interface_s.nextval
1051: INTO l_transmission_rec_id_of
1052: FROM dual;
1053:
1054: /* Insert a new overflow record for the new invoice number resolved. */
1055: INSERT INTO ar_payments_interface_all(
1056: transmission_record_id,