APPS.CE_JE_CREATION dependencies on CE_STATEMENT_HEADERS

Line 12: g_p_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;

8: g_p_report_mode CE_LOOKUPS.lookup_code%TYPE;
9: g_request_id NUMBER(15);
10: g_p_bank_branch_id NUMBER(15);
11: g_p_bank_account_id NUMBER(15);
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;

Line 13: g_p_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;

9: g_request_id NUMBER(15);
10: g_p_bank_branch_id NUMBER(15);
11: g_p_bank_account_id NUMBER(15);
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:

Line 14: g_p_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;

10: g_p_bank_branch_id NUMBER(15);
11: g_p_bank_account_id NUMBER(15);
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

Line 15: g_p_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;

11: g_p_bank_account_id NUMBER(15);
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: --

Line 49: ce_statement_headers csh

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
53: AND csh.statement_number BETWEEN

Line 99: ce_statement_headers sh,

95: ba.multi_currency_allowed_flag,
96: jem.trxn_subtype_code_id
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,

Line 806: l_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;

802: p_statement_date_to VARCHAR2) IS
803: --p_gl_date VARCHAR2,
804: --p_report_mode VARCHAR2) IS
805: l_last_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := -1;
806: l_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
807: l_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
808: l_result VARCHAR2(50);
809: l_req_id NUMBER;
810: BEGIN