APPS.QA_PLAN_ELEMENT_API dependencies on GME_BATCH_STEP_RESOURCES

Line 1864: FROM GME_BATCH_STEP_RESOURCES

1860: id NUMBER;
1861: CURSOR c (l_resources VARCHAR2, l_batch_id NUMBER,
1862: l_batchstep_id NUMBER, l_activity_id NUMBER) is
1863: SELECT BATCHSTEP_RESOURCE_ID
1864: FROM GME_BATCH_STEP_RESOURCES
1865: WHERE RESOURCES = L_RESOURCES
1866: AND BATCH_ID = L_BATCH_ID
1867: AND BATCHSTEP_ID = L_BATCHSTEP_ID
1868: AND BATCHSTEP_ACTIVITY_ID = L_ACTIVITY_ID;

Line 4533: 'FROM GME_BATCH_STEP_RESOURCES GBSR, CR_RSRC_MST_VL CRMV '||

4529: l_activity_id := get_process_activity_id(p_process_activity, l_batch_id, l_batchstep_id);
4530: wild := value;
4531:
4532: sql_string := 'SELECT GBSR.RESOURCES, CRMV.RESOURCE_DESC '||
4533: 'FROM GME_BATCH_STEP_RESOURCES GBSR, CR_RSRC_MST_VL CRMV '||
4534: 'WHERE GBSR.RESOURCES like :1 '||
4535: 'AND GBSR.BATCHSTEP_ACTIVITY_ID =:2 '||
4536: 'AND GBSR.BATCHSTEP_ID =:3 '||
4537: 'AND GBSR.BATCH_ID =:4 '||