APPS.FV_FACTS_TRX_REGISTER dependencies on GL_PERIODS

Line 461: l_period_set_name Gl_Periods.period_set_name%TYPE;

457: PROCEDURE get_period_year (p_period_from VARCHAR2,
458: p_period_to VARCHAR2)
459: IS
460: l_module_name VARCHAR2(200);
461: l_period_set_name Gl_Periods.period_set_name%TYPE;
462: BEGIN
463: l_module_name := g_module_name || 'get_period_year';
464: BEGIN
465: SELECT period_set_name

Line 492: FROM gl_periods

488:
489: BEGIN
490: SELECT period_year,adjustment_period_flag
491: INTO g_period_year,g_adjustment_flag
492: FROM gl_periods
493: WHERE period_set_name = l_period_set_name
494: AND period_name = p_period_from;
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN