APPS.IEX_STRATEGY_WORK_PUB dependencies on IEX_STRY_TEMP_WORK_ITEMS_VL

Line 435: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b

431: -- ctlee - 7/15 fulfillment fax method available
432: begin
433: select upper(b.category_type)
434: into l_dunning_method
435: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b
436: where a.work_item_template_id = b.work_item_temp_id
437: and a.work_item_id = l_workitem_id
438: and b.work_type = 'AUTOMATIC';
439: l_dunning_rec.dunning_method := l_dunning_method; -- default

Line 778: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b

774: and b.delinquency_id = p_delinquency_id;
775:
776: cursor c_get_witem_temp(p_work_item_id NUMBER) is
777: select a.post_execution_wait, a.execution_time_uom, a.schedule_wait, a.schedule_uom
778: from IEX_STRY_TEMP_WORK_ITEMS_VL a, IEX_STRATEGY_WORK_ITEMS b
779: where b.work_item_template_id = a.work_item_temp_id
780: and b.work_item_id = p_work_item_id;
781:
782: l_fulfillment_wait date;

Line 1625: select a.xdo_template_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b

1621: where a.strategy_id = b.strategy_id and b.work_item_id = p_work_item_id;
1622:
1623: -- ctlee using xdo template id
1624: cursor c_get_xdo_template(p_work_item_id NUMBER) is
1625: select a.xdo_template_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1626: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1627:
1628: cursor c_get_fulfillment_template(p_work_item_id NUMBER) is
1629: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b

Line 1629: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b

1625: select a.xdo_template_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1626: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1627:
1628: cursor c_get_fulfillment_template(p_work_item_id NUMBER) is
1629: select fulfil_temp_id from IEX_STRY_TEMP_WORK_ITEMS_VL a, iex_strategy_work_items b
1630: where a.work_item_temp_id = b.work_item_template_id and work_item_id = p_work_item_id;
1631:
1632: cursor c_get_party(p_work_item_id number) is
1633: select a.party_id, a.party_type, a.party_name,

Line 1961: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b

1957: -- ctlee - 7/15 fulfillment fax method available
1958: begin
1959: select upper(b.category_type)
1960: into l_dunning_method
1961: from iex_strategy_work_items a, IEX_STRY_TEMP_WORK_ITEMS_VL b
1962: where a.work_item_template_id = b.work_item_temp_id
1963: and a.work_item_id = l_workitem_id
1964: and b.work_type = 'AUTOMATIC';
1965: l_dunning_rec.dunning_method := l_dunning_method; -- default