APPS.IRC_ITA_SHD SQL Statements

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

Line: 68

    select
       template_association_id
      ,template_id
      ,default_association
      ,job_id
      ,position_id
      ,organization_id
      ,start_date
      ,end_date
      ,object_version_number
    from        irc_template_associations
    where       template_association_id = p_template_association_id;

Line: 142

    select
       template_association_id
      ,template_id
      ,default_association
      ,job_id
      ,position_id
      ,organization_id
      ,start_date
      ,end_date
      ,object_version_number
    from        irc_template_associations
    where       template_association_id = p_template_association_id
    for update nowait;