APPS.IRC_NOTIFICATION_DATA_PKG SQL Statements

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

Line: 35

      select vacancy_id
      from per_all_assignments_f
      where assignment_id = c_assignmentId
        and trunc(c_effectiveDate)
             between trunc(effective_start_date) and trunc(effective_end_date);

Line: 64

      select person_id
      from per_all_assignments_f
      where assignment_id = c_assignmentId
       and trunc(c_effectiveDate)
             between trunc(effective_start_date) and trunc(effective_end_date);

Line: 70

      select person_id
      from per_all_assignments_f
      where assignment_id = c_assignmentId
      and rownum<2;

Line: 104

      select 'IRC_CAND_AGENCY_ID:'
             || inp.agency_id
             || ';'

Line: 136

      select manager_id
      from per_all_vacancies
      where vacancy_id = c_vacancyId
        and trunc(c_effectiveDate)
             between trunc(date_from) and nvl(trunc(date_to),to_date('31-12-4712','DD-MM-RRRR'));

Line: 164

      select recruiter_id
      from per_all_assignments_f
      where assignment_id = c_assignmentId
        and trunc(c_effectiveDate)
             between trunc(effective_start_date) and trunc(effective_end_date);

Line: 192

      select 'IRC_VACANCY_NAME:'
             || pav.name
             || ';IRC_VAC_BG_ID:'

Line: 247

      select 'IRC_COMM_TOPIC_SUBJECT:'
             || ict.SUBJECT
             || ';IRC_COMM_MSG_SENDER_TYPE:'

Line: 265

      select length(icm.MESSAGE_BODY)
      from  IRC_COMM_MESSAGES icm
      where icm.COMMUNICATION_TOPIC_ID   = c_topicId
        and icm.COMMUNICATION_MESSAGE_ID = c_messageId;

Line: 305

      select 'IRC_INTVW_LOC_ID:'
             || pe.location_id
             || ';IRC_INTVW_LOC_DETAILS:'

Line: 386

      select * into loc_rec from hr_locations_all
      where location_id=l_location_id;

Line: 402

      l_sqlbuf := 'select '||v_segment_name|| ' from ' || l_table_name||' where location_id= '||l_location_id;

Line: 446

      select 'IRC_'
             || c_role
             || '_HZP_ID:'
             || per.party_id
             || ';IRC_'

Line: 493

      select 'IRC_JOB_APPL_NEW_STATUS:'
             || per_system_status
             || ';IRC_APPL_NEW_EXTERNAL_STATUS:'

Line: 522

      select 'IRC_JOB_APPL_NEW_STATUS:'
             || per_system_status
             || ';IRC_JOB_APPL_NEW_USER_STATUS:'

Line: 552

      select c_attributeName
             || ':'
             || meaning
             || ';'

Line: 581

      select 'IRC_JOB_APPL_OLD_STATUS:'
             || external_status
             || ';'

Line: 611

    select '
'
           || ppf.full_name
           || '
' interviewer
    from per_all_people_f ppf
         , per_bookings pb
    where ppf.person_id = pb.person_id
      and pb.event_id = c_interviewId
      and trunc(c_effectiveDate) between trunc(ppf.effective_start_date) and trunc(ppf.effective_end_date);