[Home] [Help]
APPS.PQP_GB_PSI_FUNCTIONS dependencies on PER_TIME_PERIODS
Line 986: FROM per_time_periods ptp
982: ,p_effective_date DATE
983: )
984: IS
985: SELECT min(ptp.end_date) next_payroll_date
986: FROM per_time_periods ptp
987: ,per_all_assignments_f paaf
988: WHERE ptp.payroll_id = paaf.payroll_id
989: AND paaf.assignment_id = p_assignment_id
990: AND ptp.end_date >= p_effective_date ;