[Home] [Help]
215: AND (trunc(cpp.period_end_date) + 0.99999) AND
216: (wt.transaction_type = 17 -- Added 17 to support Direct Items as part of eAM support in PAC
217: OR (wt.transaction_type in (1,2,3,6) AND
218: EXISTS ( SELECT 1
219: FROM wip_pac_actual_cost_details wpacd
220: WHERE wpacd.transaction_id = wt.transaction_id AND
221: wpacd.pac_period_id = i_period_id AND
222: wpacd.cost_group_id = i_cost_group_id)
223: ))