APPS.IEX_STRATEGY_PUB dependencies on IEX_STRATEGY_WORK_ITEMS

Line 1489: iex_strategy_work_items w,

1485:
1486: Cursor c_strategy(p_delinquency_id number, p_object_id number, p_object_type varchar2) is
1487: select s.strategy_id, st.strategy_name, s.next_work_item_id, t.name from iex_strategies s,
1488: iex_strategy_templates_vl st,
1489: iex_strategy_work_items w,
1490: iex_stry_temp_work_items_vl t
1491: where ((s.delinquency_id = p_delinquency_id and
1492: s.object_id = p_object_id and s.object_type = p_object_type)) and
1493: (s.checklist_yn IS NULL or s.checkList_YN = 'N')

Line 1503: iex_strategy_work_items w,

1499: --Start bug 6723540 gnramasa 02 Jan 08
1500: Cursor c_cont_strategy(p_object_id number, p_object_type varchar2) is
1501: select s.strategy_id, st.strategy_name, s.next_work_item_id, t.name from iex_strategies s,
1502: iex_strategy_templates_vl st,
1503: iex_strategy_work_items w,
1504: iex_stry_temp_work_items_vl t
1505: where (s.object_id = p_object_id and s.object_type = p_object_type) and
1506: (s.checklist_yn IS NULL or s.checkList_YN = 'N')
1507: and s.strategy_template_id = st.strategy_temp_id(+)