DBA Data[Home] [Help]

APPS.CE_JE_CREATION dependencies on FND_CURRENCIES

Line 11: csh_currency_code FND_CURRENCIES.currency_code%TYPE;

7: -- Statement header variables
8: csh_statement_header_id number(10);--CE_STATEMENT_HEADERS_ALL.statement_header_id%TYPE;
9: csh_bank_account_id CE_STATEMENT_HEADERS.bank_account_id%TYPE;
10: csh_bank_account_ccid CE_GL_ACCOUNTS_CCID.ASSET_CODE_COMBINATION_ID%TYPE;
11: csh_currency_code FND_CURRENCIES.currency_code%TYPE;
12: csh_statement_date DATE;
13: csh_statement_gl_date DATE;
14: ba_currency_code FND_CURRENCIES.currency_code%TYPE;
15:

Line 14: ba_currency_code FND_CURRENCIES.currency_code%TYPE;

10: csh_bank_account_ccid CE_GL_ACCOUNTS_CCID.ASSET_CODE_COMBINATION_ID%TYPE;
11: csh_currency_code FND_CURRENCIES.currency_code%TYPE;
12: csh_statement_date DATE;
13: csh_statement_gl_date DATE;
14: ba_currency_code FND_CURRENCIES.currency_code%TYPE;
15:
16: -- added for R12
17: ba_legal_entity_id NUMBER(15);
18:

Line 30: csl_currency_code FND_CURRENCIES.currency_code%TYPE;

26: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
27: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
28: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
29: csl_amount CE_STATEMENT_LINES.amount%TYPE;
30: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
31: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
32: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
33: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
34: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 70: sys_currency_code FND_CURRENCIES.currency_code%TYPE;

66:
67: --
68: -- CE system parameters variables
69: --
70: sys_currency_code FND_CURRENCIES.currency_code%TYPE;
71: sys_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
72: sys_exchange_rate_date VARCHAR2(10); --CE_SYSTEM_PARAMETERS.exchange_rate_date%TYPE;
73: sys_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
74:

Line 111: je_currency_code FND_CURRENCIES.currency_code%TYPE;

107:
108: /*
109: je_sob_id CE_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
110: je_accounting_date DATE;
111: je_currency_code FND_CURRENCIES.currency_code%TYPE;
112: je_date_created DATE;
113: je_created_by NUMBER;
114: je_code_combination_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
115: je_user_curr_conversion_type GL_DAILY_RATES.conversion_type%TYPE;