[Home] [Help]
653: --Below cursor fetches further period type details of the current assignment
654: CURSOR csr_period_type_info(p_period_type VARCHAR2)
655: IS
656: SELECT ptpt.number_per_fiscal_year
657: FROM per_time_period_types ptpt
658: WHERE p_period_type = ptpt.period_type;
659:
660: CURSOR get_week_53_start(p_payroll_id NUMBER, p_prl_max_period_number NUMBER, p_prl_start_year DATE, p_prl_end_year DATE) IS
661: SELECT start_date