DBA Data[Home] [Help]

APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 60: PER_ALL_ASSIGNMENTS_F A

56: NO_OF_MANAGERS,
57: MANAGER_NAME
58: FROM
59: PER_ALL_PEOPLE_F E,
60: PER_ALL_ASSIGNMENTS_F A
61: WHERE (E.CURRENT_EMPLOYEE_FLAG = 'Y' OR
62: E.CURRENT_NPW_FLAG = 'Y')
63: AND A.PERSON_ID = E.PERSON_ID
64: AND A.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 119: FROM PER_ALL_ASSIGNMENTS_F A,

115: INTO NO_OF_ORGS,
116: ORGANIZATION_NAME,
117: MANAGER_FLAG_DESC,
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