APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_PARAMETERS

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:

Line 1224: -- Resolution: Added code to get mtl_parameters.process_enabled_flag.

1220: --
1221: -- Bug 5044147 umoogala 13-Feb-2006
1222: -- Issue: For process organizations, costed_flag is getting set to
1223: -- 'N' instead of opm_costed_flag.
1224: -- Resolution: Added code to get mtl_parameters.process_enabled_flag.
1225: -- Then in insert stmt, setting the costed_flag's based on
1226: -- variable value.
1227: --
1228: l_prev_organization_id BINARY_INTEGER := NULL;

Line 1278: -- Resolution: Added code to get mtl_parameters.process_enabled_flag.

1274: --
1275: -- Bug 5044147 umoogala 13-Feb-2006
1276: -- Issue: For process organizations, costed_flag is getting set to
1277: -- 'N' instead of opm_costed_flag.
1278: -- Resolution: Added code to get mtl_parameters.process_enabled_flag.
1279: -- Then in insert stmt, setting the costed_flag's based on
1280: -- variable value.
1281: --
1282: IF l_prev_organization_id IS NULL OR

Line 1289: FROM mtl_parameters

1285: l_prev_organization_id := p_mtl_trx_tbl(i).ORGANIZATION_ID;
1286:
1287: SELECT NVL(process_enabled_flag, 'N')
1288: INTO l_process_enabled_flag
1289: FROM mtl_parameters
1290: WHERE organization_id = p_mtl_trx_tbl(i).ORGANIZATION_ID;
1291: END IF;
1292:
1293: