APPS.CE_AUTO_BANK_IMPORT dependencies on CE_BANK_ACCTS_GT_V

Line 13: FROM ce_bank_accts_gt_v aba

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';
17: --AND aba.account_type = CE_AUTO_BANK_MATCH.get_security_account_type(aba.account_type);

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 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: