DBA Data[Home] [Help]

APPS.AR_PREPAYMENTS_PUB dependencies on HZ_CUST_ACCOUNTS

Line 83: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,

79: p_maturity_date IN DATE DEFAULT NULL,
80: p_postmark_date IN DATE DEFAULT NULL,
81: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
82: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
83: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
84: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
85: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
86: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
87: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,

Line 183: hz_cust_accounts hca,

179: cr.customer_site_use_id
180: FROM ar_cash_receipts_all cr,
181: ar_receipt_methods rm,
182: ar_receipt_classes rc,
183: hz_cust_accounts hca,
184: hz_parties party
185: WHERE cr.cash_receipt_id = l_cash_receipt_id
186: AND hca.party_id = party.party_id
187: AND hca.cust_account_id = cr.pay_from_customer