[Home] [Help]
3784: cr.receipt_date
3785: FROM ar_cash_receipts_all cr,
3786: ar_receipt_methods rm,
3787: ar_receipt_classes rc,
3788: hz_cust_accounts hca,
3789: hz_parties party
3790: WHERE cr.cash_receipt_id = p_cash_receipt_id
3791: AND hca.party_id = party.party_id
3792: AND hca.cust_account_id = cr.pay_from_customer
4316:
4317:
4318: SELECT party.party_id
4319: INTO l_party_id
4320: FROM hz_cust_accounts hca,
4321: hz_parties party
4322: WHERE hca.party_id = party.party_id
4323: AND hca.cust_account_id = l_customer_id ;
4324:
4478:
4479:
4480: SELECT party.party_id
4481: INTO l_party_id
4482: FROM hz_cust_accounts hca,
4483: hz_parties party
4484: WHERE hca.party_id = party.party_id
4485: AND hca.cust_account_id = l_customer_id ;
4486:
4609: p_postmark_date IN DATE DEFAULT NULL,
4610: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4611: /* tca uptake */
4612: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4613: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4614: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4615: /* 6612301 */
4616: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
4617: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
4932: p_postmark_date IN DATE DEFAULT NULL,
4933: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4934: /* tca uptake */
4935: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4936: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4937: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
4938: DEFAULT NULL,
4939: /* 6612301 */
4940: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE