APPS.GHR_MTI_APP SQL Statements

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

Line: 16

select ppf.first_name   FIRST_NAME,
       ppf.last_name    LAST_NAME,
       ppf.middle_names MIDDLE_NAMES,
       ppf.full_name    FULL_NAME,
       ppf.date_of_birth DATE_OF_BIRTH,
       ppf.national_identifier NATIONAL_IDENTIFIER
  from per_people_f        ppf
 where ppf.person_id    = l_person_id
   and l_effective_date between ppf.effective_start_date
             and nvl(ppf.effective_end_date,l_effective_date+1);

Line: 28

SELECT RETIREMENT_PLAN,
       RETENTION_ALLOWANCE,
       TENURE,
       ANNUITANT_INDICATOR,
       FEGLI,
       TO_POSITION_ID,
       FROM_POSITION_TITLE,
       FROM_POSITION_SEQ_NUM,
       pay_rate_determinant,
       from_step_or_rate,
       APPOINTMENT_TYPE,
       date_arrived_personnel_office,
       wgi_date_due,
       frozen_service,
       -- Bug#2412656 Added FERS_Coverage
       fers_coverage,
       non_disclosure_agmt_status,
       part_time_indicator,
       position_working_title,
       previous_retirement_coverage,
       MT_STATUS,

       FLSA_CATEGORY,
       BARGAINING_UNIT_STATUS,
       functional_class,
       supervisory_status,
       position_occupied,
       appropriation_code1,
       appropriation_code2,

       TYPE_OF_EMPLOYMENT,
       RACE_OR_NATIONAL_ORIGIN,
       AGENCY_CODE_TRANSFER_FROM,
       ORIG_APPOINTMENT_AUTH_CODE_1,
       ORIG_APPOINTMENT_AUTH_CODE_2,
       HANDICAP_CODE,

       CITIZENSHIP,
       VETERANS_PREFERENCE,
       VETERANS_PREFERENCE_FOR_RIF,
       VETERANS_STATUS,

       WORK_SCHEDULE,
       CREDITABLE_MILITARY_SERVICE,
       -- # BUG # 711533
       SERVICE_COMP_DATE,
       EDUCATIONAL_LEVEL,
       ACADEMIC_DISCIPLINE,
       YEAR_DEGREE_ATTAINED,
       -- Bug # 712305
       PART_TIME_HOURS,
       -- Bug 4093771
       to_basic_salary_rate,
       TO_ADJUSTED_BASIC_PAY,
       TO_TOTAL_SALARY
  FROM ghr_mt_interface_v
 WHERE national_identifier = p_national_identifier
   AND mt_name = p_mt_name;

Line: 88

select count(*) COUNT
 from ghr_mt_interface_v
where mt_name = p_mt_name
  and mt_status = 'E';

Line: 94

SELECT PERSON_ID
     , PERSON_EXTRA_INFO_ID
     , OBJECT_VERSION_NUMBER
  FROM PER_PEOPLE_EXTRA_INFO
 WHERE PEI_INFORMATION6  = 'Y'
   AND PEI_INFORMATION8  = to_char(p_mt_id)
   AND INFORMATION_TYPE  = 'GHR_US_PER_MASS_ACTIONS';

Line: 103

SELECT PA_REQUEST_EXTRA_INFO_ID,
       OBJECT_VERSION_NUMBER
  FROM GHR_PA_REQUEST_EXTRA_INFO
 WHERE INFORMATION_TYPE  = 'GHR_US_PAR_APPT_TRANSFER'
   and pa_request_id = p_pa_request_id;

Line: 110

SELECT PA_REQUEST_ID
  FROM GHR_MASS_TRANSFERS
 WHERE MASS_TRANSFER_ID = p_mt_id
   and TRANSFER_TYPE    = 'IN';

Line: 116

    SELECT asg.assignment_id
    FROM   per_assignments_f asg
    WHERE  asg.person_id = p_per_id
    AND    asg.assignment_type <> 'B'
    AND    trunc(p_eff_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
    ORDER BY asg.assignment_id;

Line: 259

       hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');

Line: 668

	  ghr_par_extra_info_api.update_pa_request_extra_info
 	       (p_validate                   => false,
  	        p_rei_information3           => l_agency_code_transfer_from,
  		p_rei_information4           => l_appointment_type,
  		p_rei_information6           => l_creditable_military_service,
  		p_rei_information7           => l_date_arr_pers_office,
  		p_rei_information8           => l_date_wgi_due,
  	        p_rei_information9           => l_frozen_service,
  		p_rei_information10           => l_handicap_code,
                p_rei_information11          => l_non_disc_agmt_status,
------  		p_rei_information12          => l_orig_appointment_auth_code1,
------  		p_rei_information13          => l_orig_appointment_auth_code2,
  		p_rei_information14          => l_part_time_indicator,
  		p_rei_information15          => l_position_working_title,
  		p_rei_information16          => l_previous_retirement_coverage,
  		p_rei_information18          => l_race_or_national_origin,
  		p_rei_information19          => l_type_of_employment,
		-- Bug#2412656 Added fers_coverage
		p_rei_information21          => l_fers_coverage,
                p_pa_request_extra_info_id   => l_PA_REQUEST_EXTRA_INFO_ID,
                p_object_version_number      => l_pa_OBJECT_VERSION_NUMBER);

Line: 723

        update ghr_mass_transfers
           set status = 'E'
         where mass_transfer_id = p_mtin_id;

Line: 750

        update ghr_mass_transfers
           set status = 'E'
         where mass_transfer_id = p_mtin_id;

Line: 778

        update ghr_mass_transfers
           set status = decode(l_mt_status_err_cnt,0,'P','E')
         where mass_transfer_id = p_mtin_id;

Line: 784

          hr_utility.set_location('Err in Update mass_transfers Sql err '||sqlerrm(sqlcode),30);

Line: 789

        update ghr_mass_transfers
           set status = 'E'
         where mass_transfer_id = p_mtin_id;

Line: 803

      update ghr_mass_transfers
         set status = 'E'
       where mass_transfer_id = p_mtin_id;

Line: 830

      update ghr_mass_transfers
         set status = 'E'
       where mass_transfer_id = p_mtin_id;

Line: 1159

    p_sf52_rec.last_updated_by                  := null;

Line: 1160

    p_sf52_rec.last_update_date                 := null;

Line: 1161

    p_sf52_rec.last_update_login                := null;