DBA Data[Home] [Help]

APPS.FV_GTAS_TRX_REGISTER dependencies on GL_PERIODS

Line 847: l_period_set_name Gl_Periods.period_set_name%TYPE;

843: PROCEDURE GET_PERIOD_YEAR (p_period_from VARCHAR2,
844: p_period_to VARCHAR2)
845: IS
846: l_module VARCHAR2(200):= g_module || 'get_period_year';
847: l_period_set_name Gl_Periods.period_set_name%TYPE;
848: BEGIN
849: log(l_module, 'Begin');
850: BEGIN
851: SELECT period_set_name

Line 874: FROM gl_periods

870:
871: BEGIN
872: SELECT period_year,adjustment_period_flag
873: INTO g_period_year,g_adjustment_flag
874: FROM gl_periods
875: WHERE period_set_name = l_period_set_name
876: AND period_name = p_period_from;
877: EXCEPTION
878: WHEN NO_DATA_FOUND THEN