[Home] [Help]
103: end_date,
104: period_num,
105: ptpt.number_per_fiscal_year
106: from per_time_period_types ptpt,
107: per_time_periods ptp
108: where ptpt.period_type = ptp.period_type
109: and ptp.payroll_id = cp_payroll_id
110: and cp_effective_date between ptp.start_date
111: and ptp.end_date;