APPS.CSTPPWAS dependencies on CST_PAC_ITEM_COST_DETAILS

Line 1635: cst_pac_item_cost_details cpicd

1631:
1632: SELECT SUM(NVL(cpicd.item_cost,0))
1633: INTO l_current_period_cost
1634: FROM cst_pac_item_costs cpic,
1635: cst_pac_item_cost_details cpicd
1636: WHERE cpic.pac_period_id = p_pac_period_id
1637: AND cpic.cost_group_id = p_cost_group_id
1638: AND cpic.inventory_item_id = comp_rec.component
1639: AND cpic.cost_layer_id = cpicd.cost_layer_id

Line 2038: cst_pac_item_cost_details cpicd

2034: l_stmt_num := 190;
2035: SELECT SUM(NVL(cpicd.item_cost,0))
2036: INTO l_current_period_cost
2037: FROM cst_pac_item_costs cpic,
2038: cst_pac_item_cost_details cpicd
2039: WHERE cpic.pac_period_id = p_pac_period_id
2040: AND cpic.cost_group_id = p_cost_group_id
2041: AND cpic.inventory_item_id = comp_rec.component
2042: AND cpic.cost_layer_id = cpicd.cost_layer_id

Line 2115: cst_pac_item_cost_details cpicd

2111: l_stmt_num := 220;
2112: SELECT SUM(NVL(cpicd.item_cost,0))
2113: INTO l_current_period_cost
2114: FROM cst_pac_item_costs cpic,
2115: cst_pac_item_cost_details cpicd
2116: WHERE cpic.pac_period_id = p_pac_period_id
2117: AND cpic.cost_group_id = p_cost_group_id
2118: AND cpic.inventory_item_id = comp_rec.component
2119: AND cpic.cost_layer_id = cpicd.cost_layer_id

Line 2177: cst_pac_item_cost_details cpicd

2173: l_stmt_num := 250;
2174: SELECT SUM(NVL(cpicd.item_cost,0))
2175: INTO l_current_period_cost
2176: FROM cst_pac_item_costs cpic,
2177: cst_pac_item_cost_details cpicd
2178: WHERE cpic.pac_period_id = p_pac_period_id
2179: AND cpic.cost_group_id = p_cost_group_id
2180: AND cpic.inventory_item_id = comp_rec.component
2181: AND cpic.cost_layer_id = cpicd.cost_layer_id