DBA Data[Home] [Help]

APPS.PER_ORG_BGT_PKG dependencies on PER_ALL_ASSIGNMENTS

Line 43: , PER_ALL_ASSIGNMENTS A

39: X_MANAGER_NAME,
40: l_real_manager_name,
41: X_MANAGER_EMP_NO
42: FROM PER_ALL_PEOPLE E
43: , PER_ALL_ASSIGNMENTS A
44: WHERE E.CURRENT_EMPLOYEE_FLAG = 'Y'
45: AND A.PERSON_ID = E.PERSON_ID
46: AND A.ORGANIZATION_ID = X_ORGANIZATION_ID
47: AND A.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID