DBA Data[Home] [Help]

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