APPS.IRC_WEB SQL Statements

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

Line: 16

      select to_char(pra.posting_content_id)
      from per_recruitment_activities pra
      ,per_recruitment_activity_for prf
      where prf.vacancy_id=p_vac_id
      and pra.recruitment_activity_id=prf.recruitment_activity_id
      and pra.posting_content_id is not null
      order by pra.date_start;

Line: 79

    select person_id
    from per_all_people_f
    where party_id=l_party_id
    and business_group_id=fnd_profile.value('IRC_REGISTRATION_BG_ID');

Line: 85

    select person_id
    from per_all_people_f
    where party_id=l_party_id
    order by effective_start_date;