APPS.GMD_STATUS_PUB dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 199: FROM gmd_item_substitution_hdr_b

195: CURSOR get_curr_subst_status(vSubs_id NUMBER
196: ,vSubs_no VARCHAR2
197: ,vSubs_vers NUMBER) IS
198: SELECT substitution_id, substitution_name, substitution_version, substitution_status
199: FROM gmd_item_substitution_hdr_b
200: WHERE ((vSubs_no IS NULL AND vSubs_vers IS NULL) AND
201: (substitution_id = vSubs_id)) OR
202: ((vSubs_id IS NULL) AND
203: (substitution_name = vSubs_no AND substitution_version = vSubs_vers));