APPS.IEX_TRX_VIEW_PKG dependencies on IEX_STRATEGY_TEMPLATES_VL

Line 117: FROM iex_strategies str, iex_strategy_templates_vl str_temp

113: FUNCTION get_strategy_name(p_delinquency_id NUMBER) RETURN VARCHAR2
114: IS
115: CURSOR c_str IS
116: SELECT str.strategy_id, str.strategy_template_id, str_temp.strategy_name
117: FROM iex_strategies str, iex_strategy_templates_vl str_temp
118: WHERE str.delinquency_id = p_delinquency_id
119: AND str.strategy_template_id = str_temp.strategy_temp_id
120: AND str_temp.category_type = 'DELINQUENT';
121: l_strategy_row c_str%rowtype;

Line 219: FROM iex_strategies str, iex_strategy_templates_vl str_temp

215: and line_NUMBER = 1;
216:
217: CURSOR c_str(p_delinquency_id NUMBER) IS
218: SELECT str_temp.strategy_name
219: FROM iex_strategies str, iex_strategy_templates_vl str_temp
220: WHERE str.delinquency_id = p_delinquency_id
221: AND str.strategy_template_id = str_temp.strategy_temp_id
222: AND str_temp.category_type = 'DELINQUENT'
223: AND str.status_code IN ('OPEN', 'ONHOLD');