APPS.SO_ATT dependencies on SO_NOTE_USAGES_S

Line 208: FROM so_note_usages snu

204: BEGIN
205:
206: SELECT snu.category_id
207: INTO p_category_id
208: FROM so_note_usages snu
209: WHERE snu.usage_id = p_usage_id;
210:
211:
212: EXCEPTION

Line 227: so_note_usages snu

223:
224: SELECT snu.usage_id
225: INTO p_usage_id
226: FROM fnd_document_categories fdc,
227: so_note_usages snu
228: WHERE fdc.category_id = snu.category_id
229: AND fdc.category_id = p_category_id;
230:
231: END;

Line 1096: SELECT so_note_usages_s.nextval

1092: RETURN;
1093: END IF;
1094:
1095: CLOSE C;
1096: SELECT so_note_usages_s.nextval
1097: INTO p_usage_id
1098: FROM dual;
1099:
1100: