APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on CST_PAC_PERIOD_BALANCES

Line 1181: TYPE t_txn_category_tbl IS TABLE OF CST_PAC_PERIOD_BALANCES.txn_category%TYPE

1177:
1178: l_stmt_num NUMBER;
1179: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
1180: INDEX BY BINARY_INTEGER;
1181: TYPE t_txn_category_tbl IS TABLE OF CST_PAC_PERIOD_BALANCES.txn_category%TYPE
1182: INDEX BY BINARY_INTEGER;
1183: l_last_txn_id_tbl t_txn_id_tbl;
1184: l_txn_category_tbl t_txn_category_tbl;
1185: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;

Line 1364: FROM cst_pac_period_balances cppb

1360: where inventory_item_id = p_inventory_item_id
1361: and pac_period_id = p_pac_period_id
1362: and cost_group_id = p_cost_group_id)
1363: AND EXISTS (SELECT 1
1364: FROM cst_pac_period_balances cppb
1365: WHERE cppb.pac_period_id = p_pac_period_id
1366: AND cppb.cost_group_id = p_cost_group_id
1367: AND cppb.cost_layer_id = cpicd.cost_layer_id
1368: AND cppb.cost_element_id = cpicd.cost_element_id

Line 1444: FROM cst_pac_period_balances cppb

1440: WHERE cpic.pac_period_id = p_pac_period_id
1441: AND cpic.cost_group_id = p_cost_group_id
1442: AND cpic.inventory_item_id = p_inventory_item_id
1443: AND EXISTS (SELECT 1
1444: FROM cst_pac_period_balances cppb
1445: WHERE cppb.pac_period_id = p_pac_period_id
1446: AND cppb.cost_group_id = p_cost_group_id
1447: AND cppb.cost_layer_id = cpic.cost_layer_id
1448: AND cppb.inventory_item_id = p_inventory_item_id)

Line 1523: FROM cst_pac_period_balances cppb

1519: where inventory_item_id = p_inventory_item_id
1520: and pac_period_id = p_pac_period_id
1521: and cost_group_id = p_cost_group_id)
1522: AND EXISTS (SELECT 1
1523: FROM cst_pac_period_balances cppb
1524: WHERE cppb.pac_period_id = p_pac_period_id
1525: AND cppb.cost_group_id = p_cost_group_id
1526: AND cppb.cost_layer_id = cpicd.cost_layer_id
1527: AND cppb.cost_element_id = cpicd.cost_element_id

Line 1604: FROM cst_pac_period_balances cppb

1600: WHERE cpic.pac_period_id = p_pac_period_id
1601: AND cpic.cost_group_id = p_cost_group_id
1602: AND cpic.inventory_item_id = p_inventory_item_id
1603: AND EXISTS (SELECT 1
1604: FROM cst_pac_period_balances cppb
1605: WHERE cppb.pac_period_id = p_pac_period_id
1606: AND cppb.cost_group_id = p_cost_group_id
1607: AND cppb.cost_layer_id = cpic.cost_layer_id
1608: AND cppb.inventory_item_id = p_inventory_item_id)

Line 1739: UPDATE CST_PAC_PERIOD_BALANCES cppb

1735: );
1736:
1737: -- Update cumulative period balances in CPPB for interorg receipts
1738: -- with txn category 8
1739: UPDATE CST_PAC_PERIOD_BALANCES cppb
1740: SET (last_updated_by,
1741: last_update_date,
1742: last_update_login,
1743: request_id,

Line 1799: UPDATE CST_PAC_PERIOD_BALANCES cppb

1795: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
1796: AND cppb.cost_element_id = cpicd1.cost_element_id
1797: AND cppb.level_type = cpicd1.level_type);
1798:
1799: UPDATE CST_PAC_PERIOD_BALANCES cppb
1800: SET txn_category_value =
1801: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1802: FROM mtl_pac_actual_cost_details mpacd,
1803: mtl_material_transactions mmt

Line 3584: FROM cst_pac_period_balances

3580: IS
3581: SELECT
3582: nvl(period_quantity,0)
3583: , nvl(period_balance,0)
3584: FROM cst_pac_period_balances
3585: WHERE pac_period_id = c_pac_period_id
3586: AND cost_group_id = c_cost_group_id
3587: AND inventory_item_id = c_inventory_item_id
3588: AND cost_element_id = c_cost_element_id