DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 1015: FROM per_time_periods ptp

1011: ,p_effective_date DATE
1012: )
1013: IS
1014: SELECT min(ptp.end_date) next_payroll_date
1015: FROM per_time_periods ptp
1016: ,per_all_assignments_f paaf
1017: WHERE ptp.payroll_id = paaf.payroll_id
1018: AND paaf.assignment_id = p_assignment_id
1019: AND ptp.end_date >= p_effective_date ;