118: MANAGER_FLAG
119: FROM PER_ALL_ASSIGNMENTS_F A,
120: HR_ALL_ORGANIZATION_UNITS O,
121: HR_ALL_ORGANIZATION_UNITS_TL OTL,
122: FND_LOOKUPS L
123: WHERE A.PERSON_ID = P_PERSON_ID
124: AND (A.ASSIGNMENT_TYPE = 'E' OR A.ASSIGNMENT_TYPE = 'C')
125: --Added for Bug 6010637
126: AND (SELECT PER_SYSTEM_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES PAST