APPS.PA_PACCGLER_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 88: HR_ORGANIZATION_INFORMATION HRI

84: NAME
85: INTO L_LEGAL_ENTITY_NAME
86: FROM
87: XLE_ENTITY_PROFILES XEP,
88: HR_ORGANIZATION_INFORMATION HRI
89: WHERE LEGAL_ENTITY_ID = HRI.ORG_INFORMATION2
90: AND ORGANIZATION_ID = P_ORG_ID
91: AND ORG_INFORMATION_CONTEXT = 'Operating Unit Information';
92: RETURN (L_LEGAL_ENTITY_NAME);