DBA Data[Home] [Help]

APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 58: PER_ALL_ASSIGNMENTS_F A

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

Line 117: FROM PER_ALL_ASSIGNMENTS_F A,

113: INTO NO_OF_ORGS,
114: ORGANIZATION_NAME,
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