686:
687: cursor c_number_per_year
688: (p_type in per_time_periods.period_type%type) is
689: select number_per_fiscal_year
690: from per_time_period_types
691: where period_type = p_type;
692:
693: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
694: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;
689: select number_per_fiscal_year
690: from per_time_period_types
691: where period_type = p_type;
692:
693: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
694: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;
695: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%TYPE;
696: l_start_date VARCHAR2(50);
697:
691: where period_type = p_type;
692:
693: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
694: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;
695: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%TYPE;
696: l_start_date VARCHAR2(50);
697:
698: BEGIN
699: