DBA Data[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 ;