APPS.GMD_SPEC_VRS_GRP dependencies on CR_RSRC_DTL

Line 324: FROM GMP_RESOURCE_INSTANCES ri, CR_RSRC_DTL rd

320: and delete_mark = 0;
321:
322: cursor c_resource_instance is
323: SELECT ri.INSTANCE_NUMBER
324: FROM GMP_RESOURCE_INSTANCES ri, CR_RSRC_DTL rd
325: WHERE rd.resource_id = ri.resource_id
326: AND rd.organization_id = NVL(l_mon_vr.resource_organization_id, rd.organization_id)
327: AND rd.resources = NVL(l_mon_vr.resources, rd.resources)
328: AND ri.INACTIVE_IND = 0