APPS.IEX_STRY_UTL_PUB dependencies on IEX_STRY_TEMP_WORK_ITEMS_B

Line 1291: iex_stry_temp_work_items_b stry_temp_wkitem

1287: wkitem.work_item_order wkitem_order,
1288: wkitem.escalated_yn escalated_yn
1289: from iex_strategies strat,
1290: iex_strategy_work_items wkitem,
1291: iex_stry_temp_work_items_b stry_temp_wkitem
1292: where wkitem.work_item_id=p_work_item_id
1293: AND wkitem.strategy_id = strat.strategy_id
1294: AND wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id;
1295:

Line 1657: iex_stry_temp_work_items_b b

1653:
1654: cursor c_fulfil_wf(p_resource_id number) is
1655: select work_item_id
1656: from iex_strategy_work_items a,
1657: iex_stry_temp_work_items_b b
1658: where a.work_item_template_id = b.work_item_temp_id
1659: and b.work_type = 'AUTOMATIC'
1660: and a.resource_id = p_resource_id;
1661:

Line 1665: iex_stry_temp_work_items_b b

1661:
1662: cursor c_custom_wf(p_resource_id number) is
1663: select work_item_id, b.workflow_item_type
1664: from iex_strategy_work_items a,
1665: iex_stry_temp_work_items_b b
1666: where a.work_item_template_id = b.work_item_temp_id
1667: and b.work_type = 'WORKFLOW'
1668: and a.resource_id = p_resource_id;
1669: