APPS.CE_JE_CREATION dependencies on CE_BANK_ACCOUNTS

Line 16: g_multi_currency CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;

12: g_p_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
13: g_p_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
14: g_p_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
15: g_p_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
16: g_multi_currency CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
17:
18: -- Main cursors
19: --
20: -- Cursor for bank accounts as per the

Line 28: FROM CE_BANK_ACCOUNTS_V ba -- 14555941: Used view CE_BANK_ACCOUNTS_V

24: p_bank_account_id NUMBER)IS
25: SELECT
26: ba.bank_account_id,
27: ba.account_owner_org_id
28: FROM CE_BANK_ACCOUNTS_V ba -- 14555941: Used view CE_BANK_ACCOUNTS_V
29: WHERE
30: ba.bank_branch_id = p_bank_branch_id
31: AND ba.bank_account_id = NVL(p_bank_account_id, ba.bank_account_id);
32: -- AND ba.account_type =

Line 48: ce_bank_accounts ba,

44: p_statement_date_to DATE) IS
45: SELECT
46: csh.statement_header_id
47: FROM
48: ce_bank_accounts ba,
49: ce_statement_headers csh
50: WHERE
51: ba.bank_account_id = NVL(p_bank_account_id,ba.bank_account_id)
52: AND csh.bank_account_id = ba.bank_account_id

Line 101: ce_bank_accounts ba,

97: FROM
98: ce_statement_lines sl,
99: ce_statement_headers sh,
100: -- ap_bank_accounts ba,
101: ce_bank_accounts ba,
102: ce_je_mappings_v jem
103: --ce_bank_acct_uses_all use,
104: --ce_gl_accounts_ccid cc
105: WHERE

Line 854: l_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;

850: --p_gl_date VARCHAR2,
851: --p_report_mode VARCHAR2) IS
852: l_last_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := -1;
853: l_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
854: l_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
855: l_result VARCHAR2(50);
856: l_req_id NUMBER;
857: BEGIN
858: log('>> create_journal');

Line 898: ce_bank_accounts ba

894: CE_JE_CREATION.sys_sob_id
895: FROM
896: ce_system_parameters sys, -- change to base table per BH's request
897: gl_sets_of_books sob,
898: ce_bank_accounts ba
899: --xle_fp_ou_ledger_v xle
900: WHERE
901: sys.set_of_books_id = sob.set_of_books_id
902: AND sys.legal_entity_id = ba.account_owner_org_id