APPS.IRC_IPD_SHD SQL Statements

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

Line: 52

    select
       pending_data_id
      ,email_address
      ,vacancy_id
      ,last_name
      ,first_name
      ,user_password
      ,resume_file_name
      ,resume_description
      ,resume_mime_type
      ,source_type
      ,job_post_source_name
      ,posting_content_id
      ,person_id
      ,processed
      ,sex
      ,date_of_birth
      ,per_information_category
      ,per_information1
      ,per_information2
      ,per_information3
      ,per_information4
      ,per_information5
      ,per_information6
      ,per_information7
      ,per_information8
      ,per_information9
      ,per_information10
      ,per_information11
      ,per_information12
      ,per_information13
      ,per_information14
      ,per_information15
      ,per_information16
      ,per_information17
      ,per_information18
      ,per_information19
      ,per_information20
      ,per_information21
      ,per_information22
      ,per_information23
      ,per_information24
      ,per_information25
      ,per_information26
      ,per_information27
      ,per_information28
      ,per_information29
      ,per_information30
      ,error_message
      ,creation_date
      ,last_update_date
      ,allow_access
      ,user_guid
      ,visitor_resp_key
      ,visitor_resp_appl_id
      ,security_group_key
    from        irc_pending_data
    where       pending_data_id = p_pending_data_id;

Line: 164

    select
       pending_data_id
      ,email_address
      ,vacancy_id
      ,last_name
      ,first_name
      ,user_password
      ,resume_file_name
      ,resume_description
      ,resume_mime_type
      ,source_type
      ,job_post_source_name
      ,posting_content_id
      ,person_id
      ,processed
      ,sex
      ,date_of_birth
      ,per_information_category
      ,per_information1
      ,per_information2
      ,per_information3
      ,per_information4
      ,per_information5
      ,per_information6
      ,per_information7
      ,per_information8
      ,per_information9
      ,per_information10
      ,per_information11
      ,per_information12
      ,per_information13
      ,per_information14
      ,per_information15
      ,per_information16
      ,per_information17
      ,per_information18
      ,per_information19
      ,per_information20
      ,per_information21
      ,per_information22
      ,per_information23
      ,per_information24
      ,per_information25
      ,per_information26
      ,per_information27
      ,per_information28
      ,per_information29
      ,per_information30
      ,error_message
      ,creation_date
      ,last_update_date
      ,allow_access
      ,user_guid
      ,visitor_resp_key
      ,visitor_resp_appl_id
      ,security_group_key
    from        irc_pending_data
    where       pending_data_id = p_pending_data_id
    for update nowait;

Line: 316

  ,p_last_update_date               in date
  ,p_allow_access                   in varchar2
  ,p_user_guid                      in raw
  ,p_visitor_resp_key               in varchar2
  ,p_visitor_resp_appl_id           in number
  ,p_security_group_key             in varchar2
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 380

  l_rec.last_update_date                 := p_last_update_date;