227: ) RETURN NUMBER
228: AS
229: CURSOR c_ptp IS
230: SELECT end_date
231: FROM per_time_periods
232: WHERE time_definition_id = p_time_definition_id
233: AND end_date BETWEEN p_payroll_start_date
234: AND p_payroll_end_date ;
235:
2002: ,PRD_INFORMATION2
2003: ,PRD_INFORMATION3
2004: ,PRD_INFORMATION4
2005: ,PRD_INFORMATION5
2006: FROM per_time_periods
2007: WHERE payroll_id = p_payroll_id
2008: AND start_date = p_payroll_start_date
2009: AND end_date = p_payroll_end_date;
2010: