[Home] [Help]
APPS.GHR_VALIDATE_PAYWSMEE SQL Statements
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Line: 11
SELECT tpe.start_date
FROM per_time_periods tpe
WHERE tpe.payroll_id = p_payroll_id
AND tpe.start_date >= p_wgi_due_date
ORDER BY tpe.start_date;
Line: 32
SELECT 1
FROM per_time_periods tpe
WHERE tpe.payroll_id = p_payroll_id
AND tpe.start_date = p_date;