APPS.IEX_STRY_API_PUB dependencies on IEX_STRATEGIES

Line 115: from iex_strategies

111: l_prev_status varchar2(100) ;
112:
113: cursor c_status(p_strategy_id IN NUMBER) is
114: select status_code
115: from iex_strategies
116: where strategy_id = p_strategy_id ;
117:
118: cursor c_object(p_strategy_id IN NUMBER) is
119: select delinquency_id,object_id,object_type

Line 120: from iex_strategies

116: where strategy_id = p_strategy_id ;
117:
118: cursor c_object(p_strategy_id IN NUMBER) is
119: select delinquency_id,object_id,object_type
120: from iex_strategies
121: where strategy_id = p_strategy_id ;
122:
123: BEGIN
124:

Line 473: select count(*) INTO v_result from iex_strategies

469: -- then the send signal has been successful and it has created
470: -- the next work item . other wise, the send signal failed.
471: -- id send signal is successful, commit , else rollback
472: /* comment out by kali and ctlee
473: select count(*) INTO v_result from iex_strategies
474: where strategy_id =p_strategy_work_item_rec.strategy_id
475: and next_work_item_id =p_strategy_work_item_rec.work_item_id
476: and status_code ='OPEN';
477:

Line 609: select count(*) INTO v_result from iex_strategies

605: -- then the send signal has been successful and it has created
606: -- the next work item . other wise, the send signal failed.
607: -- id send signal is successful, commit , else rollback
608: /* comment out by kali and ctlee
609: select count(*) INTO v_result from iex_strategies
610: where strategy_id =l_strategy_work_item_rec.strategy_id
611: and next_work_item_id =l_strategy_work_item_rec.work_item_id
612: and status_code ='OPEN';
613: