DBA Data[Home] [Help]

APPS.FTE_WSH_INTERFACE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 2916: FROM HR_ORGANIZATION_UNITS HOU,

2912: SELECT DECODE(FPG.MULTI_ORG_FLAG,'Y',
2913: DECODE(HOI2.ORG_INFORMATION_CONTEXT,'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION3),
2914: TO_NUMBER(NULL)),
2915: TO_NUMBER(NULL)) OPERATING_UNIT
2916: FROM HR_ORGANIZATION_UNITS HOU,
2917: HR_ORGANIZATION_INFORMATION HOI2,
2918: FND_PRODUCT_GROUPS FPG
2919: WHERE HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
2920: AND( HOI2.ORG_INFORMATION_CONTEXT || '')='Accounting Information'