APPS.HR_ATTACHMENTS_LOADER dependencies on FND_DOC_CATEGORY_USAGES

Line 103: from fnd_doc_category_usages

99: where name=p_category_name;
100: --
101: cursor category_exists(p_category_id NUMBER) is
102: select doc_category_usage_id
103: from fnd_doc_category_usages
104: where attachment_function_id=p_attachment_function_id
105: and category_id=p_category_id;
106: --
107: l_category_id NUMBER;

Line 130: select fnd_doc_category_usages_s.nextval

126: fetch category_exists into l_doc_category_usages_id;
127: if(category_exists%NOTFOUND) then
128: close category_exists;
129: -- if not associated, then add it
130: select fnd_doc_category_usages_s.nextval
131: into l_doc_category_usages_id
132: from sys.dual;
133: --
134: INSERT INTO fnd_doc_category_usages(

Line 134: INSERT INTO fnd_doc_category_usages(

130: select fnd_doc_category_usages_s.nextval
131: into l_doc_category_usages_id
132: from sys.dual;
133: --
134: INSERT INTO fnd_doc_category_usages(
135: doc_category_usage_id,
136: category_id,
137: attachment_function_id,
138: enabled_flag,