[Home] [Help]
694:
695: END IF;
696:
697: /*
698: From the cal_period_id in fem_cal_periods_tl, you can get the cal_period_name,
699: which will match the period_name value in GL
700: */
701:
702: SELECT cal_period_name
700: */
701:
702: SELECT cal_period_name
703: INTO l_cal_period
704: FROM fem_cal_periods_tl
705: WHERE cal_period_id = pCalPeriodId --obtained from UI parameters
706: AND language = userenv('LANG');
707:
708: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN