DBA Data[Home] [Help]

APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 119: HR_ALL_ORGANIZATION_UNITS_TL OTL,

115: MANAGER_FLAG_DESC,
116: MANAGER_FLAG
117: FROM PER_ALL_ASSIGNMENTS_F A,
118: HR_ALL_ORGANIZATION_UNITS O,
119: HR_ALL_ORGANIZATION_UNITS_TL OTL,
120: FND_LOOKUPS L
121: WHERE A.PERSON_ID = P_PERSON_ID
122: AND (A.ASSIGNMENT_TYPE = 'E' OR A.ASSIGNMENT_TYPE = 'C')
123: AND P_SESSION_DATE BETWEEN