APPS.QA_PLAN_ELEMENT_API dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1819: FROM GME_BATCH_STEP_ACTIVITIES

1815: RETURN NUMBER IS
1816: id NUMBER;
1817: CURSOR c (l_activity VARCHAR2, l_batch_id NUMBER, l_batchstep_id NUMBER) is
1818: SELECT BATCHSTEP_ACTIVITY_ID
1819: FROM GME_BATCH_STEP_ACTIVITIES
1820: WHERE ACTIVITY = L_ACTIVITY
1821: AND BATCH_ID = L_BATCH_ID
1822: AND BATCHSTEP_ID = L_BATCHSTEP_ID ;
1823: BEGIN

Line 4305: 'FROM GME_BATCH_STEP_ACTIVITIES STEPS, GMD_ACTIVITIES ACTIVITIES '||

4301: l_batchstep_id := get_process_batchstep_id(p_process_batchstep_num, l_batch_id);
4302: wild := value;
4303:
4304: sql_string := 'SELECT STEPS.ACTIVITY,ACTIVITIES.ACTIVITY_DESC '||
4305: 'FROM GME_BATCH_STEP_ACTIVITIES STEPS, GMD_ACTIVITIES ACTIVITIES '||
4306: 'WHERE STEPS.ACTIVITY like :1 '||
4307: 'AND STEPS.BATCHSTEP_ID =:2 '||
4308: 'AND STEPS.BATCH_ID =:3 '||
4309: 'AND STEPS.ACTIVITY = ACTIVITIES.ACTIVITY';