APPS.CSTPPPUR dependencies on CST_PAC_ITEM_COSTS

Line 107: FROM cst_pac_item_costs

103: l_stmt_num := 70;
104:
105: DELETE from cst_pac_quantity_layers
106: WHERE cost_layer_id in (SELECT cost_layer_id
107: FROM cst_pac_item_costs
108: WHERE pac_period_id = i_pac_period_id
109: AND cost_group_id = i_cost_group_id);
110:
111: l_stmt_num := 80;

Line 114: WHERE cost_layer_id in (SELECT cost_layer_id from cst_pac_item_costs

110:
111: l_stmt_num := 80;
112:
113: DELETE FROM cst_pac_item_cost_details
114: WHERE cost_layer_id in (SELECT cost_layer_id from cst_pac_item_costs
115: WHERE pac_period_id = i_pac_period_id
116: AND cost_group_id = i_cost_group_id);
117:
118: l_stmt_num := 90;

Line 119: DELETE FROM cst_pac_item_costs

115: WHERE pac_period_id = i_pac_period_id
116: AND cost_group_id = i_cost_group_id);
117:
118: l_stmt_num := 90;
119: DELETE FROM cst_pac_item_costs
120: WHERE pac_period_id = i_pac_period_id
121: AND cost_group_id = i_cost_group_id;
122:
123: -- l_stmt_num := 100;