APPS.GL_HISTORICAL_RATES_PKG dependencies on GL_LOOKUPS

Line 578: FROM gl_lookups_rate_type_v

574: Per GL team, the rate could be negative now.
575: */
576: SELECT rate_type
577: INTO V_Rate_Type
578: FROM gl_lookups_rate_type_v
579: WHERE X_Rate_Type = show_rate_type;
580:
581: SELECT DECODE(lookup_code, 'Average', 'A', 'S')
582: INTO V_Usage_Code

Line 583: FROM gl_lookups

579: WHERE X_Rate_Type = show_rate_type;
580:
581: SELECT DECODE(lookup_code, 'Average', 'A', 'S')
582: INTO V_Usage_Code
583: FROM gl_lookups
584: WHERE lookup_type = 'GL_HIST_RATES_USAGE' AND meaning = X_Usage_Code;
585:
586: SELECT period_year, period_num
587: INTO X_Period_Year, X_Period_Num