APPS.PER_POSITION_MAPPING SQL Statements

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

Line: 10

     cursor c1 is select position_id from hr_all_positions_f
                  where name = p_name
                  and effective_end_date = to_date('31124712','ddmmyyyy');

Line: 26

     cursor c1 is select position_definition_id from hr_all_positions_f
                  where name = p_name
                  and effective_end_date = to_date('31124712','ddmmyyyy');

Line: 85

         select    payroll_id
         from      pay_all_payrolls_f pay, fnd_sessions f
         where     payroll_name      = p_pay_freq_payroll_name
         and       f.effective_date between
                   pay.effective_start_date and pay.effective_end_date
         and       f.session_id         = userenv ('sessionid')
         and       pay.business_group_id = p_business_group_id ;

Line: 108

      select sps.step_id
   	  from	per_spinal_point_steps_f sps, per_spinal_points psp
      where p_effective_date between sps.effective_start_date
          and sps.effective_end_date
          and sps.business_group_id = psp.business_group_id
          and psp.business_group_id = p_business_group_id
          and sps.spinal_point_id = psp.spinal_point_id
          and psp.spinal_point = p_spinal_point ;

Line: 132

         select    shared_type_id
         from      per_shared_types_vl
         where     shared_type_name = p_shared_type_name
	 and lookup_type = 'POSITION_AVAILABILITY_STATUS'
         and system_type_cd = p_system_type_cd
         and nvl(business_group_id,p_business_group_id) = p_business_group_id;

Line: 154

     cursor c1 is select object_version_number from hr_all_positions_f
                  where name = p_name
                  and effective_end_date = to_date('31124712','ddmmyyyy');