APPS.GMD_SUBSTITUTION_PUB dependencies on GMD_STATUS

Line 57: l_status_code GMD_STATUS.Status_Code%TYPE;

53: SELECT substitution_status
54: FROM gmd_item_substitution_hdr_b
55: WHERE substitution_id = p_substitution_id;
56:
57: l_status_code GMD_STATUS.Status_Code%TYPE;
58: l_delete_mark NUMBER := 0;
59: BEGIN
60: OPEN get_subs_info(p_substitution_id);
61: FETCH get_subs_info INTO l_status_code;