APPS.CSTPPIPV dependencies on MTL_PARAMETERS

Line 83: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;

79:
80:
81: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
82:
83: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
84: l_organization_code mtl_parameters.organization_code%TYPE;
85:
86: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 End */
87:

Line 84: l_organization_code mtl_parameters.organization_code%TYPE;

80:
81: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
82:
83: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
84: l_organization_code mtl_parameters.organization_code%TYPE;
85:
86: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 End */
87:
88: /* Invoice Lines Project: lookup_code needs to be ITEM and ACCRUAL, not just ITEM */

Line 191: FROM mtl_parameters

187: , organization_code
188: INTO l_default_cost_group_id
189: , l_process_enabled_flag
190: , l_organization_code
191: FROM mtl_parameters
192: WHERE organization_id = l_org_id;
193:
194: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
195: l_err_num := 30001;

Line 335: FROM mtl_parameters mp

331: l_stmt_num := 20;
332:
333: SELECT mp.primary_cost_method
334: INTO l_cost_method
335: FROM mtl_parameters mp
336: WHERE mp.organization_id = l_org_id;
337:
338: IF (l_cost_method <> 2) THEN
339: RAISE CST_NO_AVG_ORG;

Line 1371: mtl_parameters mp,

1367: FROM cst_ap_variance_headers cavh,
1368: po_distributions_all pda,
1369: wip_operation_resources wor,
1370: org_acct_periods oap,
1371: mtl_parameters mp,
1372: fnd_user fu
1373: WHERE cavh.batch_id = l_batch_id
1374: AND cavh.var_amount <> 0
1375: AND pda.po_distribution_id = cavh.po_distribution_id

Line 1481: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;

1477: conc_status BOOLEAN;
1478:
1479: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
1480:
1481: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
1482: l_organization_code mtl_parameters.organization_code%TYPE;
1483:
1484: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 End */
1485:

Line 1482: l_organization_code mtl_parameters.organization_code%TYPE;

1478:
1479: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
1480:
1481: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
1482: l_organization_code mtl_parameters.organization_code%TYPE;
1483:
1484: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 End */
1485:
1486: BEGIN

Line 1492: FROM mtl_parameters

1488: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
1489: BEGIN
1490: SELECT nvl(process_enabled_flag,'N'), organization_code
1491: INTO l_process_enabled_flag, l_organization_code
1492: FROM mtl_parameters
1493: WHERE organization_id = p_organization_id;
1494:
1495: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
1496: l_err_num := 30001;

Line 1624: from mtl_parameters

1620: l_err_msg := '';
1621:
1622: select default_cost_group_id
1623: into l_default_cost_group_id
1624: from mtl_parameters
1625: where organization_id = p_organization_id;
1626: ---------------------------------------------------------------------
1627: -- Get all relevant records
1628: ---------------------------------------------------------------------