DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on GL_PERIODS

Line 493: l_period_set_name Gl_Periods.period_set_name%TYPE;

489: PROCEDURE get_period_year (p_period_from VARCHAR2,
490: p_period_to VARCHAR2)
491: IS
492: l_module_name VARCHAR2(200);
493: l_period_set_name Gl_Periods.period_set_name%TYPE;
494: BEGIN
495: l_module_name := g_module_name || 'get_period_year';
496: BEGIN
497: SELECT period_set_name

Line 524: FROM gl_periods

520:
521: BEGIN
522: SELECT period_year,adjustment_period_flag
523: INTO g_period_year,g_adjustment_flag
524: FROM gl_periods
525: WHERE period_set_name = l_period_set_name
526: AND period_name = p_period_from;
527: EXCEPTION
528: WHEN NO_DATA_FOUND THEN