APPS.GHR_VALIDATE_PAYWSMEE dependencies on PER_TIME_PERIODS
Line 12: FROM per_time_periods tpe
8: ,p_payroll_id IN NUMBER)
9: return DATE IS
10: CURSOR cur_tpe IS
11: SELECT tpe.start_date 12: FROM per_time_periods tpe 13: WHERE tpe.payroll_id = p_payroll_id
14: AND tpe.start_date >= p_wgi_due_date
15: ORDER BY tpe.start_date;
16: --
Line 33: FROM per_time_periods tpe
29: ,p_payroll_id IN NUMBER)
30: RETURN BOOLEAN IS
31: CURSOR cur_tpe IS
32: SELECT 1 33: FROM per_time_periods tpe 34: WHERE tpe.payroll_id = p_payroll_id
35: AND tpe.start_date = p_date;
36: --
37: BEGIN