APPS.GMD_STATUS_PUB dependencies on GMD_ITEM_SUBSTITUTION_HDR_B
Line 203: FROM gmd_item_substitution_hdr_b
199: CURSOR get_curr_subst_status(vSubs_id NUMBER
200: ,vSubs_no VARCHAR2
201: ,vSubs_vers NUMBER) IS
202: SELECT substitution_id, substitution_name, substitution_version, substitution_status 203: FROM gmd_item_substitution_hdr_b 204: WHERE ((vSubs_no IS NULL AND vSubs_vers IS NULL) AND
205: (substitution_id = vSubs_id)) OR
206: ((vSubs_id IS NULL) AND
207: (substitution_name = vSubs_no AND substitution_version = vSubs_vers));