DBA Data[Home] [Help]

APPS.PAY_FI_GENERAL dependencies on PER_TIME_PERIODS

Line 231: FROM per_time_periods

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:

Line 2006: FROM per_time_periods

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: