APPS.CSTPPWAS dependencies on CST_PAC_ITEM_COST_DETAILS

Line 1226: cst_pac_item_cost_details cpicd

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

Line 1608: cst_pac_item_cost_details cpicd

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

Line 1685: cst_pac_item_cost_details cpicd

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

Line 1747: cst_pac_item_cost_details cpicd

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