APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_STABILITY_SPEC_VRS

Line 83: FROM GMD_STABILITY_SPEC_VRS V

79: FROM GMD_MONITORING_SPEC_VRS V
80: WHERE v.spec_vr_id = lSpecVRId
81: UNION
82: SELECT 'T' spec_type
83: FROM GMD_STABILITY_SPEC_VRS V
84: WHERE v.spec_vr_id = lSpecVRId;
85:
86:
87: /*=======================================

Line 231: FROM GMD_STABILITY_SPEC_VRS V ,

227: to_number(NULL) resource_instance_id,
228: v.last_updated_by ,
229: TO_NUMBER(NULL),
230: NULL subinventory, NULL locator_id
231: FROM GMD_STABILITY_SPEC_VRS V ,
232: GMD_SPECIFICATIONS_B S,
233: GMD_QC_STATUS_TL p,
234: GMD_QC_STATUS_TL t
235: WHERE V.SPEC_ID = S.SPEC_ID