540: AND assignment_id = c_assignment_id;
541:
542: Cursor c_get_periods_per_yr(c_period_type in VARCHAR2) IS
543: Select number_per_fiscal_year
544: from per_time_period_types
545: where period_type = c_period_type;
546:
547:
548: l_average_days_divisor NUMBER;
2095: -- =======================================================================
2096: CURSOR c_pp_cur IS
2097: SELECT pety.number_per_fiscal_year
2098: FROM pay_payrolls_f ppaf
2099: ,per_time_period_types pety
2100: WHERE ppaf.payroll_id = p_payroll_id
2101: AND ppaf.period_type = pety.period_type;
2102:
2103: -- =======================================================================
4514: AND rownum = 1;
4515:
4516: Cursor c_get_periods_per_yr(c_period_type in VARCHAR2) IS
4517: Select number_per_fiscal_year
4518: from per_time_period_types
4519: where period_type = c_period_type;
4520:
4521: BEGIN
4522: