DBA Data[Home] [Help]

APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 621: per_assignment_status_types past

617: and prior effective_end_date = ( effective_start_date - 1 )
618: ) max_end_date
619: FROM per_all_people_f pap,
620: per_all_assignments_f paa,
621: per_assignment_status_types past
622: WHERE pap.person_id = paa.person_id
623: AND ( pap.person_id = P_EmployeeId or ( P_QryType = 'MANAGER' AND paa.supervisor_id = P_EmployeeId ) )
624: AND P_StartDate <= paa.effective_end_date
625: AND P_EndDate >= paa.effective_start_date