APPS.XTR_ORACLE_FIN_INTERFACES_P dependencies on GL_DAILY_CONVERSION_TYPES

Line 376: l_xchange_type gl_daily_conversion_types.user_conversion_type%TYPE;

372: l_set_of_books gl_sets_of_books.set_of_books_id%TYPE := to_number(NULL);
373: l_trx_param xtr_company_parameters.parameter_value_code%TYPE;
374: l_source_name gl_je_sources.user_je_source_name%TYPE;
375: l_category_name gl_je_categories.user_je_category_name%TYPE;
376: l_xchange_type gl_daily_conversion_types.user_conversion_type%TYPE;
377: l_gl_link_id XTR_JOURNALS.gl_sl_link_id%TYPE;
378: l_gl_group_id GL_INTERFACE.group_id%TYPE; -- add to record group id when tranfer
379: p_company_code XTR_PARTY_INFO.party_code%TYPE;
380: l_rowid VARCHAR2(30);

Line 486: from gl_daily_conversion_types

482: where je_category_name = 'Treasury';
483: --
484: cursor EXCHANGE_TYPE is
485: select user_conversion_type
486: from gl_daily_conversion_types
487: where conversion_type = (select conversion_type
488: from xtr_parties_v
489: where party_code = p_company_code);
490: --