DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on CE_BANK_ACCOUNTS

Line 911: /* removed ap_bank_accounts to point to ce_bank_accounts */

907: FROM ar_receipt_methods
908: WHERE name = p_value;
909: /* REMOVED the defaulting of the bank_account_id from CUSTOMER_BANK_ACCOUNT_NUMBER, CUSTOMER_BANK_ACCOUNT_NAME */
910:
911: /* removed ap_bank_accounts to point to ce_bank_accounts */
912: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NUMBER')
913: THEN
914: SELECT bank_account_id
915: INTO l_selected_id

Line 916: FROM ce_bank_accounts

912: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NUMBER')
913: THEN
914: SELECT bank_account_id
915: INTO l_selected_id
916: FROM ce_bank_accounts
917: WHERE bank_account_num = p_value
918: AND pg_deposit_date < NVL(end_date,
919: TO_DATE('01/01/2200',
920: 'DD/MM/YYYY') );

Line 926: FROM ce_bank_accounts

922: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NAME')
923: THEN
924: SELECT bank_account_id
925: INTO l_selected_id
926: FROM ce_bank_accounts
927: WHERE bank_account_name = p_value
928: AND pg_deposit_date < NVL(end_date,
929: TO_DATE('01/01/2200',
930: 'DD/MM/YYYY') );