DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on IEX_STRY_TEMP_WORK_ITEMS_VL

Line 18473: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b

18469: else
18470: begin -- bug 14772139 start....
18471: select nvl(b.INCLUDE_CURRENT,'N') ,nvl(INCLUDE_UNUSED_PAYMENTS_FLAG,'N')
18472: into l_include_curr_inv, l_include_unapp_rec
18473: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b
18474: where a.work_item_template_id = b.work_item_temp_id
18475: and a.work_item_id = p_workitem_id -- p_grace_days -- indicating workitem Id when p_ag_dn_xref_id is 0 from iexpstmb.pls
18476: and b.work_type in ('AUTOMATIC','WORKFLOW'); -- bug 14772139
18477: --and b.work_type = 'AUTOMATIC'; -- bug 14772139