DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 409: HR_ORGANIZATION_INFORMATION HOI,

405: FROM WSH_SHIPPING_PARAMETERS
406: WHERE ORGANIZATION_ID IN (
407: SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID
408: FROM HR_ORGANIZATION_UNITS HOU,
409: HR_ORGANIZATION_INFORMATION HOI,
410: FND_PRODUCT_GROUPS FPG
411: WHERE HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
412: AND DECODE ( FPG.MULTI_ORG_FLAG, 'Y',
413: DECODE (HOI.ORG_INFORMATION_CONTEXT, 'Accounting Information',