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 1325: mtl_parameters mp,

1321: FROM cst_ap_variance_headers cavh,
1322: po_distributions_all pda,
1323: wip_operation_resources wor,
1324: org_acct_periods oap,
1325: mtl_parameters mp,
1326: fnd_user fu
1327: WHERE cavh.batch_id = l_batch_id
1328: AND cavh.var_amount <> 0
1329: AND pda.po_distribution_id = cavh.po_distribution_id

Line 1435: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;

1431: conc_status BOOLEAN;
1432:
1433: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
1434:
1435: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
1436: l_organization_code mtl_parameters.organization_code%TYPE;
1437:
1438: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 End */
1439:

Line 1436: l_organization_code mtl_parameters.organization_code%TYPE;

1432:
1433: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
1434:
1435: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;
1436: l_organization_code mtl_parameters.organization_code%TYPE;
1437:
1438: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 End */
1439:
1440: BEGIN

Line 1446: FROM mtl_parameters

1442: /* Skip Process Organizations Cost Manager Changes - Anand Thiyagarajan - 26-Oct-2004 Start */
1443: BEGIN
1444: SELECT nvl(process_enabled_flag,'N'), organization_code
1445: INTO l_process_enabled_flag, l_organization_code
1446: FROM mtl_parameters
1447: WHERE organization_id = p_organization_id;
1448:
1449: IF nvl(l_process_enabled_flag,'N') = 'Y' THEN
1450: l_err_num := 30001;

Line 1578: from mtl_parameters

1574: l_err_msg := '';
1575:
1576: select default_cost_group_id
1577: into l_default_cost_group_id
1578: from mtl_parameters
1579: where organization_id = p_organization_id;
1580: ---------------------------------------------------------------------
1581: -- Get all relevant records
1582: ---------------------------------------------------------------------