APPS.CSTPPPUR dependencies on CST_PAC_PERIODS

Line 145: FROM cst_pac_periods

141: actual_eqp_cost = 0
142: WHERE legal_entity_id = i_legal_entity
143: AND cost_group_id = i_cost_group_id
144: AND cost_type_id = (SELECT cost_type_id
145: FROM cst_pac_periods
146: WHERE pac_period_id = i_pac_period_id);
147:
148: l_stmt_num := 130;
149: DELETE FROM cst_pac_eam_asset_per_balances

Line 159: FROM cst_pac_periods

155: AND NVL(system_estimated_eqp_cost,0) = 0
156: AND legal_entity_id = i_legal_entity
157: AND cost_group_id = i_cost_group_id
158: AND cost_type_id = (SELECT cost_type_id
159: FROM cst_pac_periods
160: WHERE pac_period_id = i_pac_period_id);
161:
162: l_stmt_num := 140;
163: -- Delete cpepb rows with zeros in ALL value columns

Line 229: FROM cst_le_cost_types clct, cst_pac_periods cpp

225: decode(NVL(clct.transfer_cost_flag,'N'),'N',0,1),
226: 1),
227: SYSDATE,
228: NULL
229: FROM cst_le_cost_types clct, cst_pac_periods cpp
230: WHERE cpp.pac_period_id = i_pac_period_id
231: AND clct.legal_entity = i_legal_entity
232: AND clct.cost_type_id = cpp.cost_type_id)
233: WHERE cppp.pac_period_id = i_pac_period_id