APPS.PER_PERRPREQ_XMLP_PKG SQL Statements

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

Line: 13

insert into fnd_sessions (session_id, effective_date)
       select userenv('sessionid'), trunc(sysdate)
       from   dual
       where not exists
             (select 1
              from   fnd_sessions fs
              where fs.session_id = userenv('sessionid'));

Line: 20

select bg.name
INTO v_business_group
FROM per_business_groups bg
WHERE bg.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;

Line: 32

   SELECT NAME
   INTO L_ORG_NAME
   FROM HR_ORGANIZATION_UNITS
   WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 44

   SELECT NAME
   INTO L_JOB
   FROM PER_JOBS_VL
   WHERE JOB_ID = P_JOB_ID;

Line: 56

   SELECT NAME
   INTO L_POSITION
   FROM PER_POSITIONS
   WHERE POSITION_ID = P_POSITION_ID;

Line: 68

   SELECT NAME
   INTO L_GRADE
   FROM PER_GRADES_VL
   WHERE GRADE_ID = P_GRADE_ID;

Line: 80

   SELECT LOCATION_CODE
   INTO L_LOCATION
   FROM HR_LOCATIONS
   WHERE LOCATION_ID = P_LOCATION_ID;

Line: 92

   SELECT NAME
   INTO L_RECRUITMENT
   FROM PER_RECRUITMENT_ACTIVITIES
   WHERE RECRUITMENT_ACTIVITY_ID = P_RECRUITMENT_ACTIVITY_ID;

Line: 104

   SELECT NAME
   INTO L_REQUISITION
   FROM PER_REQUISITIONS
   WHERE REQUISITION_ID = P_REQUISITION_ID;

Line: 116

   SELECT USER_STATUS
   INTO L_APPS_STATUS
   FROM PER_ASSIGNMENT_STATUS_TYPES
   WHERE ASSIGNMENT_STATUS_TYPE_ID = P_APPLICANT_STATUS_ID;

Line: 128

   SELECT MEANING
   INTO L_VAC_STATUS
   FROM hr_lookups
   WHERE LOOKUP_TYPE = 'VACANCY_STATUS'
   AND LOOKUP_CODE = P_VACANCY_STATUS;