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 185: hz_parties party,

181: FROM ar_cash_receipts_all cr,
182: ar_receipt_methods rm,
183: ar_receipt_classes rc,
184: hz_cust_accounts hca,
185: hz_parties party,
186: /* Need to pass country code for SEPA specific receipts */
187: ce_bank_acct_uses bau,
188: ce_bank_accounts cba,
189: hz_parties bank,

Line 189: hz_parties bank,

185: hz_parties party,
186: /* Need to pass country code for SEPA specific receipts */
187: ce_bank_acct_uses bau,
188: ce_bank_accounts cba,
189: hz_parties bank,
190: hz_organization_profiles pr
191: WHERE cr.cash_receipt_id = l_cash_receipt_id
192: AND hca.party_id = party.party_id
193: AND hca.cust_account_id = cr.pay_from_customer