DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on CE_BANK_ACCOUNTS

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

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

Line 918: FROM ce_bank_accounts

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

Line 928: FROM ce_bank_accounts

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