DBA Data[Home] [Help]

APPS.PAY_PAYSGI21_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 467: per_assignment_status_types past

463: and paf.primary_flag = 'Y'
464: and paf.effective_start_date =
465: (select max(paf1.effective_start_date)
466: from per_assignments_f paf1,
467: per_assignment_status_types past
468: where paf1.person_id = paf.person_id
469: and paf1.assignment_status_type_id = past.assignment_status_type_id
470: and past.per_system_status = 'ACTIVE_ASSIGN'
471: and paf1.assignment_type = 'E'