DBA Data[Home] [Help]

APPS.XTR_CSH_FCST_POP dependencies on GL_CURRENCIES

Line 642: FROM gl_currencies

638: --------------------------------------------------------------------- */
639: PROCEDURE Execute_Main_Query (main_query VARCHAR2) IS
640: CURSOR C_cur(p_cur VARCHAR2) IS
641: SELECT nvl(derive_type, 'NONE')
642: FROM gl_currencies
643: WHERE currency_code(+) = p_cur;
644:
645: CURSOR C_period(p_pid NUMBER) IS
646: SELECT end_date,

Line 660: currency GL_CURRENCIES.currency_code%TYPE;

656: amount_date DATE;
657: company_code XTR_PARTY_INFO.party_code%TYPE;
658: trx_type CE_FORECAST_ROWS.trx_type%TYPE;
659: level_of_summary XTR_FORECAST_PERIODS.level_of_summary%TYPE;
660: currency GL_CURRENCIES.currency_code%TYPE;
661: bank_account_id NUMBER;
662: forecast_amount NUMBER;
663:
664: l_emu GL_CURRENCIES.currency_code%TYPE;

Line 664: l_emu GL_CURRENCIES.currency_code%TYPE;

660: currency GL_CURRENCIES.currency_code%TYPE;
661: bank_account_id NUMBER;
662: forecast_amount NUMBER;
663:
664: l_emu GL_CURRENCIES.currency_code%TYPE;
665: error_msg fnd_new_messages.message_text%TYPE;
666: BEGIN
667:
668: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN