DBA Data[Home] [Help]

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 )