DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on GMO_BATCH_STEPS_V

Line 1795: FROM GMO_BATCH_STEPS_V

1791: id NUMBER;
1792:
1793: CURSOR c (l_operation VARCHAR2, l_batch_id NUMBER, l_batchstep_id VARCHAR2) is
1794: SELECT OPRN_ID
1795: FROM GMO_BATCH_STEPS_V
1796: WHERE OPERATION = L_OPERATION
1797: AND BATCH_ID = L_BATCH_ID
1798: AND BATCHSTEP_ID = L_BATCHSTEP_ID;
1799: BEGIN

Line 4278: 'FROM GMO_BATCH_STEPS_V '||

4274: l_batchstep_id := get_process_batchstep_id(p_process_batchstep_num, l_batch_id);
4275: wild := value;
4276:
4277: sql_string := 'SELECT OPERATION PROCESS_OPERATION, OPRN_DESC '||
4278: 'FROM GMO_BATCH_STEPS_V '||
4279: 'WHERE OPERATION like :1 '||
4280: 'AND BATCHSTEP_ID = :2 '||
4281: 'AND BATCH_ID =:3';
4282: