DBA Data[Home] [Help]

APPS.AR_PREPAYMENTS_PUB dependencies on HZ_PARTIES

Line 82: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,

78: p_gl_date IN ar_cash_receipt_history.gl_date%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,

Line 184: hz_parties party

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
188: AND cr.receipt_method_id = rm.receipt_method_id