APPS.CSTPPBBS dependencies on CST_PAC_PERIOD_BALANCES

Line 222: FROM cst_pac_period_balances

218: l_stmt_num := 25;
219: l_count := 0;
220: SELECT count(1)
221: INTO l_count
222: FROM cst_pac_period_balances
223: WHERE pac_period_id = i_pac_period_id
224: AND cost_group_id = i_cost_group_id
225: AND rownum = 1;
226:

Line 428: -- Copy prior info of CST_PAC_PERIOD_BALANCES --

424: AND cpic.cost_group_id = cpql.cost_group_id
425: AND cpic.inventory_item_id = cpql.inventory_item_id;
426:
427: ------------------------------------------------
428: -- Copy prior info of CST_PAC_PERIOD_BALANCES --
429: ------------------------------------------------
430:
431: /* Bug 5496879 If the prior period was closed with pre R12 code, txn_category 10
432: (ending balance line) would not have been created. So insert begining balance

Line 437: INSERT INTO cst_pac_period_balances (

433: txn_category 1 from CPIC and CPICD instead of prior period CPPB */
434: /* Note: this might cause regression to Bug 5337969 as Exp item data is inserted into CPPB */
435:
436: l_stmt_num := 55;
437: INSERT INTO cst_pac_period_balances (
438: pac_period_id,
439: cost_group_id,
440: inventory_item_id,
441: cost_layer_id,