APPS.GMD_SPEC_VRS_GRP dependencies on CR_RSRC_DTL

Line 335: FROM GMP_RESOURCE_INSTANCES ri, CR_RSRC_DTL rd

331: and delete_mark = 0;
332:
333: cursor c_resource_instance is
334: SELECT ri.INSTANCE_NUMBER
335: FROM GMP_RESOURCE_INSTANCES ri, CR_RSRC_DTL rd
336: WHERE rd.resource_id = ri.resource_id
337: AND rd.organization_id = NVL(l_mon_vr.resource_organization_id, rd.organization_id)
338: AND rd.resources = NVL(l_mon_vr.resources, rd.resources)
339: AND ri.INACTIVE_IND = 0