APPS.GMA_PURGE_ENGINE dependencies on GME_MATERIAL_DETAILS

Line 1862: FROM gme_material_details

1858: cursor cur_phantoms(p_batch_id GME_BATCH_HEADER.batch_id%type) is
1859: select batch_id,batch_status,gl_posted_ind,update_inventory_ind
1860: FROM GME_BATCH_HEADER
1861: WHERE batch_id IN (SELECT DISTINCT batch_id
1862: FROM gme_material_details
1863: START WITH batch_id=P_batch_id
1864: CONNECT BY batch_id = PRIOR phantom_id);
1865: -- AND GL_POSTED_IND<>1
1866: -- AND BATCH_STATUS not in( -1,-3);