DBA Data[Home] [Help]

APPS.ARP_AUTO_ACCOUNTING_BR dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 942: -- Retrieves default ccids from the table ar_receipt_method_accounts

938: --
939: -- PROCEDURE NAME: get_pym_bact_ccids
940: --
941: -- DECSRIPTION:
942: -- Retrieves default ccids from the table ar_receipt_method_accounts
943: -- for a given payment methods bank account
944: --
945: -- ARGUMENTS:
946: -- IN:

Line 992: FROM ar_receipt_method_accounts

988: SELECT
989: nvl(br_factor_ccid,-1),
990: nvl(br_remittance_ccid,-1)
991: INTO p_ccid_factor, p_ccid_remittance
992: FROM ar_receipt_method_accounts
993: WHERE remit_bank_acct_use_id = p_bank_account_id
994: AND receipt_method_id = p_receipt_method_id ;
995:
996: -- update cache

Line 2827: ELSIF( l_tbl = 'AR_RECEIPT_METHOD_ACCOUNTS' ) THEN

2823: ELSIF p_account_class = REMITTANCE THEN
2824: l_ccid := p_ccid_record.site_use_ccid_remittance;
2825: END IF;
2826:
2827: ELSIF( l_tbl = 'AR_RECEIPT_METHOD_ACCOUNTS' ) THEN
2828: IF p_account_class = FACTOR THEN
2829: l_ccid := p_ccid_record.pym_bact_ccid_factor;
2830: ELSIF p_account_class = REMITTANCE THEN
2831: l_ccid := p_ccid_record.pym_bact_ccid_remittance;