eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_ZBA_DEAL_GENERATION dependencies on CE_STATEMENT_HEADERS

Line 11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;

7:
8: -- Statement headers
9: --
10: csh_rowid VARCHAR2(100);
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;

Line 12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;

8: -- Statement headers
9: --
10: csh_rowid VARCHAR2(100);
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;

Line 13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;

9: --
10: csh_rowid VARCHAR2(100);
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;

Line 14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;

10: csh_rowid VARCHAR2(100);
11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;

Line 15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;

11: csh_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
12: csh_statement_date CE_STATEMENT_HEADERS.statement_date%TYPE;
13: csh_statement_gl_date CE_STATEMENT_HEADERS.gl_date%TYPE;
14: csh_check_digits CE_STATEMENT_HEADERS.check_digits%TYPE;
15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;

Line 19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;

15: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
20: csh_statement_complete_flag CE_STATEMENT_HEADERS.statement_complete_flag%TYPE;
21: csh_org_id CE_STATEMENT_HEADERS.org_id%TYPE;
22: --
23: -- Statement Lines

Line 20: csh_statement_complete_flag CE_STATEMENT_HEADERS.statement_complete_flag%TYPE;

16: cba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
20: csh_statement_complete_flag CE_STATEMENT_HEADERS.statement_complete_flag%TYPE;
21: csh_org_id CE_STATEMENT_HEADERS.org_id%TYPE;
22: --
23: -- Statement Lines
24: --

Line 21: csh_org_id CE_STATEMENT_HEADERS.org_id%TYPE;

17: cba_multi_currency_flag CE_BANK_ACCOUNTS.multi_currency_allowed_flag%TYPE;
18: cba_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
19: csh_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
20: csh_statement_complete_flag CE_STATEMENT_HEADERS.statement_complete_flag%TYPE;
21: csh_org_id CE_STATEMENT_HEADERS.org_id%TYPE;
22: --
23: -- Statement Lines
24: --
25: csl_rowid VARCHAR2(100);

Line 64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;

60: --
61:
62: G_bank_branch_id CE_BANK_ACCOUNTS.bank_branch_id%TYPE;
63: G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
68: G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;

61:
62: G_bank_branch_id CE_BANK_ACCOUNTS.bank_branch_id%TYPE;
63: G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
68: G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;
69: G_debug_path VARCHAR(100);

Line 66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;

62: G_bank_branch_id CE_BANK_ACCOUNTS.bank_branch_id%TYPE;
63: G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
68: G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;
69: G_debug_path VARCHAR(100);
70: G_debug_file VARCHAR(100);

Line 67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;

63: G_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
64: G_statement_number_from CE_STATEMENT_HEADERS.statement_number%TYPE;
65: G_statement_number_to CE_STATEMENT_HEADERS.statement_number%TYPE;
66: G_statement_date_from CE_STATEMENT_HEADERS.statement_date%TYPE;
67: G_statement_date_to CE_STATEMENT_HEADERS.statement_date%TYPE;
68: G_display_debug FND_LOOKUP_VALUES.lookup_code%TYPE;
69: G_debug_path VARCHAR(100);
70: G_debug_file VARCHAR(100);
71: G_sweep_flag BOOLEAN DEFAULT FALSE;

Line 73: p_offset_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;

69: G_debug_path VARCHAR(100);
70: G_debug_file VARCHAR(100);
71: G_sweep_flag BOOLEAN DEFAULT FALSE;
72:
73: p_offset_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
74: p_cashpool_id NUMBER;
75: p_from_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
76: p_to_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
77:

Line 75: p_from_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;

71: G_sweep_flag BOOLEAN DEFAULT FALSE;
72:
73: p_offset_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
74: p_cashpool_id NUMBER;
75: p_from_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
76: p_to_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
77:
78: G_spec_revision VARCHAR2(1000) := '$Revision: 120.3 $';
79:

Line 76: p_to_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;

72:
73: p_offset_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
74: p_cashpool_id NUMBER;
75: p_from_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
76: p_to_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
77:
78: G_spec_revision VARCHAR2(1000) := '$Revision: 120.3 $';
79:
80: