APPS.GMD_SUBSTITUTION_PUB dependencies on DUAL

Line 218: from dual;

214:
215: -- get the substitution_id from sequence
216: select gmd_item_substitution_hdr_s.nextval
217: into l_substitution_id
218: from dual;
219:
220: -- substitution_description
221: IF l_substitution_hdr_rec.substitution_description IS NULL THEN
222: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line 403: from dual;

399: /* Required fields at detail level */
400: -- set the primary key
401: select gmd_item_substitution_dtl_s.nextval
402: into l_substitution_line_id
403: from dual;
404:
405: -- substitute item_id
406: IF ((l_substitution_dtl_rec.inventory_item_id IS NULL) AND
407: (l_substitution_dtl_rec.item_no IS NULL)) THEN