[Home] [Help]
233: AND (trunc(cpp.period_end_date) + 0.99999) AND
234: (wt.transaction_type = 17 -- Added 17 to support Direct Items as part of eAM support in PAC
235: OR (wt.transaction_type in (1,2,3,6) AND
236: EXISTS ( SELECT 1
237: FROM wip_pac_actual_cost_details wpacd
238: WHERE wpacd.transaction_id = wt.transaction_id AND
239: wpacd.pac_period_id = i_period_id AND
240: wpacd.cost_group_id = i_cost_group_id)
241: ))