DBA Data[Home] [Help]

APPS.FV_UTILITY dependencies on GL_PERIODS

Line 651: vl_period_set_name Gl_Periods.period_set_name%TYPE;

647: period_year OUT NOCOPY NUMBER,
648: errbuf OUT NOCOPY VARCHAR2,
649: retcode OUT NOCOPY NUMBER) IS
650: l_module_name VARCHAR2(200) := g_module_name || 'Get_Period_Year';
651: vl_period_set_name Gl_Periods.period_set_name%TYPE;
652: BEGIN
653: BEGIN
654: SELECT period_set_name
655: INTO vl_period_set_name

Line 678: FROM Gl_Periods

674:
675: BEGIN
676: SELECT period_year
677: INTO period_year
678: FROM Gl_Periods
679: WHERE period_set_name = vl_period_set_name
680: AND period_name = period_from;
681: EXCEPTION
682: WHEN NO_DATA_FOUND THEN