APPS.QA_PLAN_ELEMENT_API dependencies on GME_BATCH_STEP_RESOURCES

Line 1845: FROM GME_BATCH_STEP_RESOURCES

1841: id NUMBER;
1842: CURSOR c (l_resources VARCHAR2, l_batch_id NUMBER,
1843: l_batchstep_id NUMBER, l_activity_id NUMBER) is
1844: SELECT BATCHSTEP_RESOURCE_ID
1845: FROM GME_BATCH_STEP_RESOURCES
1846: WHERE RESOURCES = L_RESOURCES
1847: AND BATCH_ID = L_BATCH_ID
1848: AND BATCHSTEP_ID = L_BATCHSTEP_ID
1849: AND BATCHSTEP_ACTIVITY_ID = L_ACTIVITY_ID;

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

4331: l_activity_id := get_process_activity_id(p_process_activity, l_batch_id, l_batchstep_id);
4332: wild := value;
4333:
4334: sql_string := 'SELECT GBSR.RESOURCES, CRMV.RESOURCE_DESC '||
4335: 'FROM GME_BATCH_STEP_RESOURCES GBSR, CR_RSRC_MST_VL CRMV '||
4336: 'WHERE GBSR.RESOURCES like :1 '||
4337: 'AND GBSR.BATCHSTEP_ACTIVITY_ID =:2 '||
4338: 'AND GBSR.BATCHSTEP_ID =:3 '||
4339: 'AND GBSR.BATCH_ID =:4 '||