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: 63

      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: 92

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

Line: 124

      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: 152

      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: 180

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

Line: 235

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

Line: 274

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

Line: 355

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

Line: 401

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

Line: 431

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

Line: 462

    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);