DBA Data[Home] [Help]

APPS.CST_PERITEMCOSTCHANGERPT_PVT dependencies on MTL_PARAMETERS

Line 299: l_item_master_org MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

295: l_pac_period CST_PAC_PERIODS.PERIOD_NAME%TYPE;
296: l_category_set MTL_CATEGORY_SETS.CATEGORY_SET_NAME%TYPE;
297: l_item VARCHAR2 (2000);
298: l_category VARCHAR2 (2000);
299: l_item_master_org MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
300: l_currency_code VARCHAR2(15);
301:
302: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
303: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;

Line 380: FROM mtl_parameters

376: /* Get Item Master Organization Name */
377: l_stmt_num := 60;
378: SELECT organization_code
379: INTO l_item_master_org
380: FROM mtl_parameters
381: WHERE organization_id = i_item_master_org_id;
382:
383: /* Get Currency Code */
384: l_stmt_num := 65;