APPS.IEX_STRY_API_PUB dependencies on IEX_STRATEGIES

Line 114: from iex_strategies

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

Line 119: from iex_strategies

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

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

367: -- then the send signal has been successful and it has created
368: -- the next work item . other wise, the send signal failed.
369: -- id send signal is successful, commit , else rollback
370: /* comment out by kali and ctlee
371: select count(*) INTO v_result from iex_strategies
372: where strategy_id =p_strategy_work_item_rec.strategy_id
373: and next_work_item_id =p_strategy_work_item_rec.work_item_id
374: and status_code ='OPEN';
375:

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

503: -- then the send signal has been successful and it has created
504: -- the next work item . other wise, the send signal failed.
505: -- id send signal is successful, commit , else rollback
506: /* comment out by kali and ctlee
507: select count(*) INTO v_result from iex_strategies
508: where strategy_id =l_strategy_work_item_rec.strategy_id
509: and next_work_item_id =l_strategy_work_item_rec.work_item_id
510: and status_code ='OPEN';
511: