DBA Data[Home] [Help]

APPS.PER_ORG_BGT_PKG dependencies on PER_ALL_PEOPLE

Line 42: FROM PER_ALL_PEOPLE E

38: INTO X_NO_OF_MANAGERS,
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