APPS.CSTPPBBS dependencies on CST_PAC_ITEM_COSTS

Line 183: FROM cst_pac_item_costs

179: l_stmt_num := 10;
180: l_count := 0;
181: SELECT count(1)
182: INTO l_count
183: FROM cst_pac_item_costs
184: WHERE pac_period_id = i_pac_period_id
185: AND cost_group_id = i_cost_group_id
186: AND rownum = 1;
187:

Line 233: -- 1. cst_pac_item_costs --

229: END IF;
230:
231: --------------------------------------------------------------------------------
232: -- Copy data from previous period to current period of the following tables : --
233: -- 1. cst_pac_item_costs --
234: -- 2. cst_pac_item_cost_details --
235: -- 3. cst_pac_quantity_layers --
236: -- New cost_layer_id and quantity_layer_id are generated for every rows --
237: -- inserted. --

Line 240: -- Copy prior info of CST_PAC_ITEM_COSTS --

236: -- New cost_layer_id and quantity_layer_id are generated for every rows --
237: -- inserted. --
238: --------------------------------------------------------------------------------
239: -------------------------------------------
240: -- Copy prior info of CST_PAC_ITEM_COSTS --
241: -------------------------------------------
242: l_stmt_num := 30;
243: INSERT INTO cst_pac_item_costs (
244: cost_layer_id,

Line 243: INSERT INTO cst_pac_item_costs (

239: -------------------------------------------
240: -- Copy prior info of CST_PAC_ITEM_COSTS --
241: -------------------------------------------
242: l_stmt_num := 30;
243: INSERT INTO cst_pac_item_costs (
244: cost_layer_id,
245: pac_period_id,
246: cost_group_id,
247: inventory_item_id,

Line 285: cst_pac_item_costs_s.nextval,

281: program_id,
282: program_update_date,
283: last_update_login)
284: SELECT
285: cst_pac_item_costs_s.nextval,
286: i_pac_period_id,
287: cost_group_id,
288: inventory_item_id,
289: total_layer_quantity,

Line 325: FROM cst_pac_item_costs cpic

321: i_prog_app_id,
322: i_prog_id,
323: SYSDATE,
324: i_login_id
325: FROM cst_pac_item_costs cpic
326: WHERE cpic.pac_period_id = i_prior_pac_period_id
327: AND cpic.cost_group_id = i_cost_group_id;
328:
329: --------------------------------------------------

Line 372: cst_pac_item_costs cpic1,

368: i_prog_id,
369: SYSDATE,
370: i_login_id
371: FROM cst_pac_item_cost_details cpicd,
372: cst_pac_item_costs cpic1,
373: cst_pac_item_costs cpic2
374: WHERE cpicd.cost_layer_id = cpic1.cost_layer_id
375: AND cpic1.pac_period_id = i_prior_pac_period_id
376: AND cpic1.cost_group_id = i_cost_group_id

Line 373: cst_pac_item_costs cpic2

369: SYSDATE,
370: i_login_id
371: FROM cst_pac_item_cost_details cpicd,
372: cst_pac_item_costs cpic1,
373: cst_pac_item_costs cpic2
374: WHERE cpicd.cost_layer_id = cpic1.cost_layer_id
375: AND cpic1.pac_period_id = i_prior_pac_period_id
376: AND cpic1.cost_group_id = i_cost_group_id
377: AND cpic2.pac_period_id = i_pac_period_id

Line 420: cst_pac_item_costs cpic

416: i_prog_id,
417: SYSDATE,
418: i_login_id
419: FROM cst_pac_quantity_layers cpql,
420: cst_pac_item_costs cpic
421: WHERE cpql.pac_period_id = i_prior_pac_period_id
422: AND cpic.pac_period_id = i_pac_period_id
423: AND cpic.cost_group_id = i_cost_group_id
424: AND cpic.cost_group_id = cpql.cost_group_id

Line 484: FROM cst_pac_item_costs cpic,

480: i_request_id,
481: i_prog_app_id,
482: i_prog_id,
483: sysdate
484: FROM cst_pac_item_costs cpic,
485: cst_pac_item_cost_details cpicd,
486: cst_pac_quantity_layers cpql
487: WHERE cpic.cost_group_id = i_cost_group_id
488: AND cpic.pac_period_id = i_pac_period_id