DBA Data[Home] [Help]

APPS.PER_POS_BGT_PKG dependencies on PER_ALL_ASSIGNMENTS

Line 44: , PER_ALL_ASSIGNMENTS A

40: X_HOLDER_NAME,
41: l_real_holder_name,
42: X_HOLDER_EMP_NO
43: FROM PER_ALL_PEOPLE E
44: , PER_ALL_ASSIGNMENTS A
45: WHERE A.POSITION_ID = X_POSITION_ID
46: AND A.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
47: AND A.ORGANIZATION_ID = X_ORGANIZATION_ID
48: AND A.ASSIGNMENT_TYPE = 'E'