DBA Data[Home] [Help]

APPS.CST_PERITEMCOSTCHANGERPT_PVT dependencies on CST_PAC_PERIODS

Line 295: l_pac_period CST_PAC_PERIODS.PERIOD_NAME%TYPE;

291: l_stmt_num NUMBER;
292: l_legal_entity HR_LEGAL_ENTITIES.NAME%TYPE;
293: l_cost_type CST_COST_TYPES.COST_TYPE%TYPE;
294: l_cost_group CST_COST_GROUPS.COST_GROUP%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;

Line 364: FROM cst_pac_periods

360: /* Get PAC Period Name */
361: l_stmt_num := 40;
362: SELECT period_name
363: INTO l_pac_period
364: FROM cst_pac_periods
365: WHERE pac_period_id = i_pac_period_id
366: AND legal_entity = i_legal_entity_id
367: AND cost_type_id = i_cost_type_id;
368: