DBA Data[Home] [Help]

APPS.FV_UTILITY dependencies on GL_PERIODS

Line 650: vl_period_set_name Gl_Periods.period_set_name%TYPE;

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

Line 677: FROM Gl_Periods

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