APPS.CSTPPWAS dependencies on CST_PAC_ITEM_COSTS

Line 1225: FROM cst_pac_item_costs cpic,

1221: BEGIN
1222:
1223: SELECT SUM(NVL(cpicd.item_cost,0))
1224: INTO l_current_period_cost
1225: FROM cst_pac_item_costs cpic,
1226: cst_pac_item_cost_details cpicd
1227: WHERE cpic.pac_period_id = p_pac_period_id
1228: AND cpic.cost_group_id = p_cost_group_id
1229: AND cpic.inventory_item_id = comp_rec.component

Line 1607: FROM cst_pac_item_costs cpic,

1603: ELSE
1604: l_stmt_num := 190;
1605: SELECT SUM(NVL(cpicd.item_cost,0))
1606: INTO l_current_period_cost
1607: FROM cst_pac_item_costs cpic,
1608: cst_pac_item_cost_details cpicd
1609: WHERE cpic.pac_period_id = p_pac_period_id
1610: AND cpic.cost_group_id = p_cost_group_id
1611: AND cpic.inventory_item_id = comp_rec.component

Line 1684: FROM cst_pac_item_costs cpic,

1680: ---------------------------------------------------
1681: l_stmt_num := 220;
1682: SELECT SUM(NVL(cpicd.item_cost,0))
1683: INTO l_current_period_cost
1684: FROM cst_pac_item_costs cpic,
1685: cst_pac_item_cost_details cpicd
1686: WHERE cpic.pac_period_id = p_pac_period_id
1687: AND cpic.cost_group_id = p_cost_group_id
1688: AND cpic.inventory_item_id = comp_rec.component

Line 1746: FROM cst_pac_item_costs cpic,

1742: -------------------------------------------------------------
1743: l_stmt_num := 250;
1744: SELECT SUM(NVL(cpicd.item_cost,0))
1745: INTO l_current_period_cost
1746: FROM cst_pac_item_costs cpic,
1747: cst_pac_item_cost_details cpicd
1748: WHERE cpic.pac_period_id = p_pac_period_id
1749: AND cpic.cost_group_id = p_cost_group_id
1750: AND cpic.inventory_item_id = comp_rec.component