DBA Data[Home] [Help]

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));