Line 47: FROM HZ_CUST_ACCOUNTS acct,HZ_PARTIES party
43: AND aps.due_date <= trunc(sysdate);
44:
45: CURSOR ar_customer_name IS
46: SELECT PARTY_NAME 47: FROM HZ_CUST_ACCOUNTS acct,HZ_PARTIES party 48: WHERE acct.PARTY_ID=party.PARTY_ID
49: AND acct.cust_account_id = l_customer_id;
50:
51: /*