DBA Data[Home] [Help]

APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on FND_LOOKUPS

Line 122: FND_LOOKUPS L

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