APPS.AMS_COLLAB_ASSOC_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 65

   select dscript_name
   from ies_deployed_scripts
   where dscript_id = p_script_id;

Line: 72

   select template_name
   from PRP_templates_vl
   where template_id = p_template_id;

Line: 80

   SELECT association_id
   from ibc_associations
   where association_type_code = 'AMS_COLB'
   and associated_object_val1 =to_char(p_collab_assoc_rec_type.obj_id)
   and associated_object_val2 = p_collab_assoc_rec_type.obj_type;