105: --
106: -- Attachment_type of 20 is a master document
107: CURSOR VALIDATE_CONTENT(p_content_id NUMBER) IS
108: select attachment_used_by_id
109: from jtf_fm_amv_attach_vl
110: where attachment_used_by_id = p_content_id;
111:
112: CURSOR VALIDATE_QUERY(p_query_id NUMBER) IS
113: select query_id
298: --
299: -- Attachment_type of 20 is a master document
300: CURSOR VALIDATE_CONTENT(p_content_id NUMBER) IS
301: select attachment_used_by_id
302: from jtf_fm_amv_attach_vl
303: where attachment_used_by_id = p_content_id;
304:
305: CURSOR VALIDATE_QUERY(p_query_id NUMBER) IS
306: select query_id