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 1242: -- Resolution: Added code to get mtl_parameters.process_enabled_flag.

1238: --
1239: -- Bug 5044147 umoogala 13-Feb-2006
1240: -- Issue: For process organizations, costed_flag is getting set to
1241: -- 'N' instead of opm_costed_flag.
1242: -- Resolution: Added code to get mtl_parameters.process_enabled_flag.
1243: -- Then in insert stmt, setting the costed_flag's based on
1244: -- variable value.
1245: --
1246: l_prev_organization_id BINARY_INTEGER := NULL;

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

1292: --
1293: -- Bug 5044147 umoogala 13-Feb-2006
1294: -- Issue: For process organizations, costed_flag is getting set to
1295: -- 'N' instead of opm_costed_flag.
1296: -- Resolution: Added code to get mtl_parameters.process_enabled_flag.
1297: -- Then in insert stmt, setting the costed_flag's based on
1298: -- variable value.
1299: --
1300: IF l_prev_organization_id IS NULL OR

Line 1307: FROM mtl_parameters

1303: l_prev_organization_id := p_mtl_trx_tbl(i).ORGANIZATION_ID;
1304:
1305: SELECT NVL(process_enabled_flag, 'N')
1306: INTO l_process_enabled_flag
1307: FROM mtl_parameters
1308: WHERE organization_id = p_mtl_trx_tbl(i).ORGANIZATION_ID;
1309: END IF;
1310:
1311: