DBA Data[Home] [Help]

APPS.PER_ASS_STATUSES_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 41: ,HR_ORGANIZATION_INFORMATION OI1

37: X_NAME in VARCHAR2
38: ) is
39: select ORG.ORGANIZATION_ID
40: from HR_ALL_ORGANIZATION_UNITS ORG
41: ,HR_ORGANIZATION_INFORMATION OI1
42: where ORG.ORGANIZATION_ID = OI1.ORGANIZATION_ID
43: and OI1.ORG_INFORMATION_CONTEXT = 'CLASS'
44: and OI1.ORG_INFORMATION1 = 'HR_BG'
45: and OI1.ORG_INFORMATION2 = 'Y'