APPS.IRC_RTM_SHD SQL Statements

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

Line: 58

    select
       rec_team_member_id
      ,person_id
      ,party_id
      ,vacancy_id
      ,job_id
      ,start_date
      ,end_date
      ,update_allowed
      ,delete_allowed
      ,object_version_number
      ,interview_security
    from        irc_rec_team_members
    where       rec_team_member_id = p_rec_team_member_id;

Line: 133

    select
       rec_team_member_id
      ,person_id
      ,party_id
      ,vacancy_id
      ,job_id
      ,start_date
      ,end_date
      ,update_allowed
      ,delete_allowed
      ,object_version_number
      ,interview_security
    from        irc_rec_team_members
    where       rec_team_member_id = p_rec_team_member_id
    for update nowait;

Line: 216

  ,p_update_allowed                 in varchar2
  ,p_delete_allowed                 in varchar2
  ,p_object_version_number          in number
  ,p_interview_security              in varchar2
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 236

  l_rec.update_allowed                   := p_update_allowed;

Line: 237

  l_rec.delete_allowed                   := p_delete_allowed;