APPS.IEX_STRATEGY_PUB dependencies on IEX_STRY_TEMP_WORK_ITEMS_VL

Line 1590: iex_stry_temp_work_items_vl t

1586: Cursor c_strategy(p_delinquency_id number, p_object_id number, p_object_type varchar2) is
1587: select s.strategy_id, st.strategy_name, s.next_work_item_id, t.name from iex_strategies s,
1588: iex_strategy_templates_vl st,
1589: iex_strategy_work_items w,
1590: iex_stry_temp_work_items_vl t
1591: where ((s.delinquency_id = p_delinquency_id and
1592: s.object_id = p_object_id and s.object_type = p_object_type)) and
1593: (s.checklist_yn IS NULL or s.checkList_YN = 'N')
1594: and s.strategy_template_id = st.strategy_temp_id(+)

Line 1604: iex_stry_temp_work_items_vl t

1600: Cursor c_cont_strategy(p_object_id number, p_object_type varchar2) is
1601: select s.strategy_id, st.strategy_name, s.next_work_item_id, t.name from iex_strategies s,
1602: iex_strategy_templates_vl st,
1603: iex_strategy_work_items w,
1604: iex_stry_temp_work_items_vl t
1605: where (s.object_id = p_object_id and s.object_type = p_object_type) and
1606: (s.checklist_yn IS NULL or s.checkList_YN = 'N')
1607: and s.strategy_template_id = st.strategy_temp_id(+)
1608: and s.next_work_item_id = w.work_item_id