[Home] [Help]
644: -- Validating select year
645: BEGIN
646: SELECT period_year
647: INTO l_period_year
648: FROM pa_rep_period_years_v
649: WHERE period_type = l_period_type
650: AND period_year = p_select_yr
651: AND ROWNUM = 1;
652: EXCEPTION
852: -- Validating period year
853: BEGIN
854: SELECT period_year
855: INTO l_period_year
856: FROM pa_rep_period_years_v
857: WHERE period_type = l_period_type
858: AND period_year = p_period_year
859: AND ROWNUM =1;
860: