APPS.PAY_FR_MIGRATE_TIME_ANALYSIS SQL Statements

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

Line: 8

 Select  distinct asg.assignment_id
   From per_all_assignments_f asg
  Where asg.business_group_id = p_business_group_id
 order by asg.assignment_id;

Line: 14

 Select  asg.effective_start_date
        ,asg.effective_end_date
        ,asg.normal_hours
        ,asg.frequency
        ,scl.segment15 work_days
        ,asg.person_id
        ,full_name
   From per_all_assignments_f asg
       ,hr_soft_coding_keyflex scl
       ,per_all_people_f per
  Where asg.business_group_id = p_business_group_id
    and asg.assignment_id = c_assignment_id
    and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
    and asg.person_id = per.person_id
 Order by asg.effective_start_date;

Line: 31

  Select distinct contract_id
   from per_contracts_f
  where business_group_id = p_business_group_id
    and person_id = c_person_id ;

Line: 39

  Select contract_id,
         reference,
         type,
         status,
         effective_start_date,
         effective_end_date,
         person_id,
         object_version_number
   from per_contracts_f
  where business_group_id = p_business_group_id
    and contract_id = c_contract_id
    and effective_start_date
        between c_previous_start_date and c_asg_start_date
  order by  effective_start_date desc;

Line: 56

  Select count(*)
    from pay_patch_status
   where patch_number = p_business_group_id
     and patch_name = 'WORKING TIME'
     and legislation_code = 'FR';

Line: 216

                    hr_contract_api.update_contract
		    (P_VALIDATE               => false,
		     P_CONTRACT_ID            => contr_date_rec.contract_id,
		     P_EFFECTIVE_START_DATE   => l_effective_start_date,
		     P_EFFECTIVE_END_DATE     => l_effective_end_date,
		     P_OBJECT_VERSION_NUMBER  => l_obj_version_number,
		     P_PERSON_ID              => contr_date_rec.person_id,
		     P_REFERENCE              => contr_date_rec.reference,
		     P_TYPE                   => contr_date_rec.type,
		     P_STATUS                 => contr_date_rec.status,
		     P_CTR_INFORMATION10      => l_fixed_time,
		     P_CTR_INFORMATION11      => l_disp_canon_amt,
		     P_CTR_INFORMATION12      => l_units,
		     P_CTR_INFORMATION13      => l_frequency,
		     P_EFFECTIVE_DATE         => contr_date_rec.effective_start_date,
                     P_DATETRACK_MODE         => 'CORRECTION');

Line: 238

                    hr_utility.set_location('Inserting a row in correction mode',22);

Line: 239

		    hr_contract_api.update_contract
		    (P_VALIDATE               => false,
		     P_CONTRACT_ID            => contr_date_rec.contract_id,
		     P_EFFECTIVE_START_DATE   => l_effective_start_date,
		     P_EFFECTIVE_END_DATE     => l_effective_end_date,
		     P_OBJECT_VERSION_NUMBER  => l_obj_version_number,
		     P_PERSON_ID              => contr_date_rec.person_id,
		     P_REFERENCE              => contr_date_rec.reference,
		     P_TYPE                   => contr_date_rec.type,
		     P_STATUS                 => contr_date_rec.status,
		     P_CTR_INFORMATION10      => l_fixed_time,
		     P_CTR_INFORMATION11      => l_disp_canon_amt,
		     P_CTR_INFORMATION12      => l_units,
		     P_CTR_INFORMATION13      => l_frequency,
		     P_EFFECTIVE_DATE         => asg_mod_rec.effective_start_date,
		     P_DATETRACK_MODE         => 'UPDATE');

Line: 275

                   hr_utility.set_location('Inserting a row where none exist', 22);

Line: 277

                   hr_contract_api.update_contract
	           (P_VALIDATE               => false,
	            P_CONTRACT_ID            => contr_befdate_rec.contract_id,
	            P_EFFECTIVE_START_DATE   => l_effective_start_date,
	            P_EFFECTIVE_END_DATE     => l_effective_end_date,
	            P_OBJECT_VERSION_NUMBER  => l_obj_version_number,
	            P_PERSON_ID              => contr_befdate_rec.person_id,
	            P_REFERENCE              => contr_befdate_rec.reference,
	            P_TYPE                   => contr_befdate_rec.type,
	            P_STATUS                 => contr_befdate_rec.status,
	            P_CTR_INFORMATION10      => l_fixed_time,
	            P_CTR_INFORMATION11      => l_disp_canon_amt,
	            P_CTR_INFORMATION12      => l_units,
	            P_CTR_INFORMATION13      => l_frequency,
	            P_EFFECTIVE_DATE         => asg_mod_rec.effective_start_date,
                    P_DATETRACK_MODE         => 'UPDATE');

Line: 331

  INSERT INTO pay_patch_status
          (id
          ,patch_number
          ,patch_name
          ,phase
          ,applied_date
          ,legislation_code)
  SELECT
           pay_patch_status_s.nextval
          ,p_business_group_id
          ,'WORKING TIME'
          ,Null
          ,sysdate
          ,'FR'
  FROM dual;