DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on HR_ORGANIZATION_UNITS

Line 188: FROM HR_ORGANIZATION_UNITS HOU, MTL_PARAMETERS MP

184: l_count := 0;
185:
186: BEGIN
187: SELECT COUNT(1) INTO l_count
188: FROM HR_ORGANIZATION_UNITS HOU, MTL_PARAMETERS MP
189: WHERE MP.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
190: AND MP.ORGANIZATION_ID = HOU.ORGANIZATION_ID
191: AND NVL(HOU.DATE_TO, SYSDATE + 1) > Sysdate;
192:

Line 238: FROM HR_ORGANIZATION_UNITS HOU, MTL_PARAMETERS MP

234: END IF;
235:
236: BEGIN
237: SELECT COUNT(1) INTO l_count
238: FROM HR_ORGANIZATION_UNITS HOU, MTL_PARAMETERS MP
239: WHERE MP.ORGANIZATION_ID = p_mtl_trx_tbl(i).transfer_organization_id
240: AND MP.ORGANIZATION_ID = HOU.ORGANIZATION_ID
241: AND NVL(HOU.DATE_TO, SYSDATE + 1) > Sysdate;
242: