APPS.QA_PLAN_ELEMENT_API dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1838: FROM GME_BATCH_STEP_ACTIVITIES

1834: RETURN NUMBER IS
1835: id NUMBER;
1836: CURSOR c (l_activity VARCHAR2, l_batch_id NUMBER, l_batchstep_id NUMBER) is
1837: SELECT BATCHSTEP_ACTIVITY_ID
1838: FROM GME_BATCH_STEP_ACTIVITIES
1839: WHERE ACTIVITY = L_ACTIVITY
1840: AND BATCH_ID = L_BATCH_ID
1841: AND BATCHSTEP_ID = L_BATCHSTEP_ID ;
1842: BEGIN

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

4499: l_batchstep_id := get_process_batchstep_id(p_process_batchstep_num, l_batch_id);
4500: wild := value;
4501:
4502: sql_string := 'SELECT STEPS.ACTIVITY,ACTIVITIES.ACTIVITY_DESC '||
4503: 'FROM GME_BATCH_STEP_ACTIVITIES STEPS, GMD_ACTIVITIES ACTIVITIES '||
4504: 'WHERE STEPS.ACTIVITY like :1 '||
4505: 'AND STEPS.BATCHSTEP_ID =:2 '||
4506: 'AND STEPS.BATCH_ID =:3 '||
4507: 'AND STEPS.ACTIVITY = ACTIVITIES.ACTIVITY';