APPS.CSTPPBBS dependencies on CST_PAC_ITEM_COST_DETAILS

Line 234: -- 2. cst_pac_item_cost_details --

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. --
238: --------------------------------------------------------------------------------

Line 330: -- Copy prior info of CST_PAC_ITEM_COST_DETAILS --

326: WHERE cpic.pac_period_id = i_prior_pac_period_id
327: AND cpic.cost_group_id = i_cost_group_id;
328:
329: --------------------------------------------------
330: -- Copy prior info of CST_PAC_ITEM_COST_DETAILS --
331: --------------------------------------------------
332: l_stmt_num := 40;
333: INSERT INTO cst_pac_item_cost_details (
334: cost_layer_id,

Line 333: INSERT INTO cst_pac_item_cost_details (

329: --------------------------------------------------
330: -- Copy prior info of CST_PAC_ITEM_COST_DETAILS --
331: --------------------------------------------------
332: l_stmt_num := 40;
333: INSERT INTO cst_pac_item_cost_details (
334: cost_layer_id,
335: cost_element_id,
336: level_type,
337: item_cost,

Line 371: FROM cst_pac_item_cost_details cpicd,

367: i_prog_app_id,
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

Line 485: cst_pac_item_cost_details cpicd,

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
489: AND cpicd.cost_layer_id = cpic.cost_layer_id