APPS.CE_AUTO_BANK_IMPORT dependencies on CE_BANK_ACCOUNTS_V

Line 12: --FROM ce_bank_accounts_v aba

8: SELECT aba.bank_account_id,
9: aba.ACCOUNT_OWNER_ORG_ID,
10: nvl(aba.XTR_USE_ALLOWED_FLAG,'N'),
11: nvl(aba.PAY_USE_ALLOWED_FLAG,'N')
12: --FROM ce_bank_accounts_v aba
13: FROM ce_bank_accts_gt_v aba
14: WHERE aba.bank_branch_id = p_bank_branch_id
15: AND aba.bank_account_id = NVL(p_bank_account_id, aba.bank_account_id);
16: --AND aba.account_classification = 'INTERNAL';

Line 73: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba

69: ba.currency_code,
70: ba.check_digits
71: FROM ce_statement_headers rsh,
72: ce_statement_headers_int sh,
73: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
74: WHERE rsh.statement_number(+) = sh.statement_number
75: AND rsh.bank_account_id(+) = p_bank_account_id
76: AND NVL(sh.record_status_flag, 'I') <> 'T'
77: AND sh.statement_number

Line 907: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

903: csli.attribute14,
904: csli.attribute15
905: FROM ce_transaction_codes ctc,
906: ce_statement_lines_interface csli,
907: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
908: WHERE ctc.trx_code(+) = csli.trx_code
909: AND NVL(ctc.bank_account_id,aba.bank_account_id) =
910: aba.bank_account_id
911: AND csli.statement_number = G_cshi_statement_number

Line 1017: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

1013: csli.attribute15
1014: FROM --ce_transaction_codes ctc,
1015: gl_daily_conversion_types gdct,
1016: ce_statement_lines_interface csli,
1017: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1018: WHERE gdct.user_conversion_type(+) = csli.user_exchange_rate_type
1019: --AND ctc.trx_code(+) = csli.trx_code
1020: --AND NVL(ctc.bank_account_id,aba.bank_account_id) =
1021: -- aba.bank_account_id

Line 1110: (select bank_account_id from ce_bank_accounts_v

1106: (select statement_header_id
1107: from ce_intra_stmt_headers
1108: where statement_number = G_cshi_statement_number
1109: and bank_account_id in
1110: (select bank_account_id from ce_bank_accounts_v
1111: where bank_account_num = G_cshi_bank_account_num));
1112: DELETE FROM CE_INTRA_STMT_HEADERS
1113: WHERE statement_number = G_cshi_statement_number
1114: AND bank_account_id in

Line 1115: (select bank_account_id from ce_bank_accounts_v

1111: where bank_account_num = G_cshi_bank_account_num));
1112: DELETE FROM CE_INTRA_STMT_HEADERS
1113: WHERE statement_number = G_cshi_statement_number
1114: AND bank_account_id in
1115: (select bank_account_id from ce_bank_accounts_v
1116: where bank_account_num = G_cshi_bank_account_num);
1117:
1118: select ce_intra_stmt_headers_s.nextval
1119: into G_cshi_statement_header_id

Line 1597: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba

1593: --SELECT aba.account_type
1594: SELECT aba.account_classification
1595: INTO account_type
1596: FROM ce_bank_branches_v abb,
1597: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1598: WHERE aba.bank_branch_id = abb.branch_party_id
1599: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1600: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1601: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num

Line 1775: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba

1771: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1772: CE_AUTO_BANK_REC.G_interface_archive_flag
1773: FROM CE_SYSTEM_PARAMETERS_ALL s,
1774: GL_SETS_OF_BOOKS g,
1775: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
1776: WHERE ba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
1777: and ba.ACCOUNT_OWNER_ORG_ID = s.legal_entity_id
1778: and s.set_of_books_id = g.set_of_books_id;
1779: