APPS.INV_MGD_MVT_FIN_MDTR dependencies on MTL_STAT_TYPE_USAGES

Line 78: l_period_set_name mtl_stat_type_usages.period_set_name%type;

74: RETURN NUMBER IS
75: l_gl_set_of_books_id VARCHAR2(15);
76: l_last_dayofperiod DATE;
77: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Conversion_Rate';
78: l_period_set_name mtl_stat_type_usages.period_set_name%type;
79: l_period_type mtl_stat_type_usages.period_type%type;
80: l_conversion_option mtl_stat_type_usages.conversion_option%type;
81: l_conversion_type mtl_stat_type_usages.conversion_type%type;
82: l_currency_conversion_rate number;

Line 79: l_period_type mtl_stat_type_usages.period_type%type;

75: l_gl_set_of_books_id VARCHAR2(15);
76: l_last_dayofperiod DATE;
77: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Conversion_Rate';
78: l_period_set_name mtl_stat_type_usages.period_set_name%type;
79: l_period_type mtl_stat_type_usages.period_type%type;
80: l_conversion_option mtl_stat_type_usages.conversion_option%type;
81: l_conversion_type mtl_stat_type_usages.conversion_type%type;
82: l_currency_conversion_rate number;
83: l_currency_conversion_date date;

Line 80: l_conversion_option mtl_stat_type_usages.conversion_option%type;

76: l_last_dayofperiod DATE;
77: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Conversion_Rate';
78: l_period_set_name mtl_stat_type_usages.period_set_name%type;
79: l_period_type mtl_stat_type_usages.period_type%type;
80: l_conversion_option mtl_stat_type_usages.conversion_option%type;
81: l_conversion_type mtl_stat_type_usages.conversion_type%type;
82: l_currency_conversion_rate number;
83: l_currency_conversion_date date;
84:

Line 81: l_conversion_type mtl_stat_type_usages.conversion_type%type;

77: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Conversion_Rate';
78: l_period_set_name mtl_stat_type_usages.period_set_name%type;
79: l_period_type mtl_stat_type_usages.period_type%type;
80: l_conversion_option mtl_stat_type_usages.conversion_option%type;
81: l_conversion_type mtl_stat_type_usages.conversion_type%type;
82: l_currency_conversion_rate number;
83: l_currency_conversion_date date;
84:
85: BEGIN

Line 122: mtl_stat_type_usages

118: , l_period_type
119: , l_conversion_option
120: , l_conversion_type
121: FROM
122: mtl_stat_type_usages
123: WHERE
124: legal_entity_id = p_movement_transaction.entity_org_id
125: AND stat_type = p_movement_transaction.stat_type;
126:

Line 1293: -- p_stat_typ_transaction mtl_stat_type_usages data record

1289:
1290: --========================================================================
1291: -- PROCEDURE : Exchange_Rate_Calc PUBLIC
1292: -- PARAMETERS:
1293: -- p_stat_typ_transaction mtl_stat_type_usages data record
1294: -- p_movement_transaction movement transaction data record
1295: -- COMMENT : This function returns the exchange rate based on
1296: -- the conversion date that is set up in the
1297: -- statistical type info form.