APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_TIME_PERIOD_TYPES
Line 292: , per_time_period_types TPTYPE
288: ,c_date_earned IN DATE) IS
289: SELECT NVL(TPTYPE.number_per_fiscal_year,12)
290: FROM per_all_assignments_f PAA
291: , per_time_periods TPERIOD 292: , per_time_period_types TPTYPE 293: WHERE PAA.assignment_id = c_assignment_id
294: AND TPERIOD.payroll_id = PAA.payroll_id
295: AND ( c_date_earned between PAA.effective_start_date and PAA.effective_end_date)
296: AND ( c_date_earned between TPERIOD.start_date and TPERIOD.end_date )