DBA Data[Home] [Help]

APPS.GMD_QC_ERES_CHANGE_STATUS_PVT dependencies on GMD_MONITORING_SPEC_VRS

Line 104: UPDATE gmd_monitoring_spec_vrs

100: UPDATE gmd_supplier_spec_vrs
101: SET spec_vr_status = p_to_status
102: WHERE spec_vr_id = pspec_vr_id;
103: ELSIF(pentity_type = 'M') THEN
104: UPDATE gmd_monitoring_spec_vrs
105: SET spec_vr_status = p_to_status
106: WHERE spec_vr_id = pspec_vr_id;
107: END IF;
108:

Line 142: from GMD_MONITORING_SPEC_VRS

138: where spec_id = p_spec_id
139: and spec_vr_status < p_to_status
140: UNION
141: select spec_vr_id, rule_type spec_type -- R or L
142: from GMD_MONITORING_SPEC_VRS
143: where spec_id = p_spec_id
144: and spec_vr_status < p_to_status
145: UNION
146: select spec_vr_id, 'T' spec_type