APPS.GHR_SES_CONV_PKG SQL Statements

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

Line: 37

SELECT user_table_id
FROM   pay_user_tables
WHERE  user_table_name=l_user_table_name;

Line: 43

SELECT substr(user_table_name,1,4) user_table_name
FROM   pay_user_tables
WHERE  user_table_id = l_user_tab_id;

Line: 50

SELECT pei.position_id,
       pei.position_extra_info_id,
       pei.poei_information3            grade_id,
       to_number(pei.poei_information5) user_tab_id
FROM   per_position_extra_info pei
WHERE  pei.information_type = 'GHR_US_POS_VALID_GRADE'
AND    to_number(pei.poei_information5) <> l_essl_tab_id
AND    pei.position_id in
       (SELECT position_id
        from   hr_positions_f pos
        WHERE  pos.position_id = pei.position_id
        AND    business_group_id = p_business_group_id)
FOR UPDATE OF poei_information5;

Line: 68

SELECT pah.pa_history_id,
       pah.information4 , -- position_id
       pah.information9 , -- grade_id
       to_number(pah.information11) user_tab_id,
       pah.effective_date
FROM   ghr_pa_history pah
WHERE  pah.table_name    = 'PER_POSITION_EXTRA_INFO'
AND    pah.information5  = 'GHR_US_POS_VALID_GRADE'
AND    to_number(pah.information11) <> l_essl_tab_id
AND    to_number(pah.information4) in
       (SELECT position_id
        from   hr_positions_f pos
        WHERE  pos.position_id = to_number(pah.information4)
        AND    business_group_id = p_business_group_id
        AND    pah.effective_date
               between pos.effective_start_date and pos.effective_end_date
        AND    HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id)
                      NOT IN ('Eliminated','Deleted'));

Line: 89

  SELECT gdf.segment1 pay_plan
	,gdf.segment2 grade_or_level
  FROM  per_grade_definitions gdf
       ,per_grades            grd
  WHERE grd.grade_id		= l_grade_id
  AND   grd.grade_definition_id = gdf.grade_definition_id;

Line: 98

SELECT 1
FROM  hr_positions_f pos1
WHERE position_id       = l_position_id
AND   l_effective_date between effective_start_date and effective_end_date
AND   business_group_id = p_business_group_id
AND   HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos1.availability_status_id)
                      NOT IN ('Eliminated','Deleted');

Line: 109

SELECT 1
FROM  ghr_pa_history pah1
WHERE table_name     = 'PER_POSITION_EXTRA_INFO'
AND   information5   = 'GHR_US_POS_VALID_GRADE'
and   effective_date = l_effective_date
AND   to_number(information4)   = l_position_id
AND   to_number(information11)  = l_essl_tab_id;

Line: 142

SELECT per.full_name            full_name
      ,per.national_identifier  national_identifier
from   per_people_f      per
      ,per_assignments_f paf
where  paf.person_id = per.person_id
and    l_check_date
       between paf.effective_start_date and paf.effective_end_date
and    l_check_date
       between per.effective_start_date and per.effective_end_date
and    paf.position_id = l_position_id;

Line: 199

        UPDATE PER_POSITION_EXTRA_INFO
	SET    poei_information5      = to_char(l_essl_tab_id)
	WHERE  current of cur_pos_ei;

Line: 222

               l_log_text := substr(l_log_text || ', Message        : ' || 'ERROR NOT UPDATED ,',1,2000);

Line: 234

               l_log_text := substr(l_log_text || ', Message        : ' || 'Updated Successful ',1,2000);

Line: 254

	          p_log_text     => 'Error : NO Valid Extra Position Info records found for Update' ,
		  p_log_date     => sysdate);

Line: 263

	          p_log_text     => 'Total Records updated with SES equivalent plans are ' || to_char(l_counter),
		  p_log_date     => sysdate);

Line: 365

                        ghr_position_extra_info_api.update_position_extra_info
                        ( p_position_extra_info_id   =>    l_pos_ei_data.position_extra_info_id
                        , p_effective_date           =>    l_effective_date
                        , p_object_version_number    =>    l_pos_ei_data.object_version_number
                        , p_poei_information3        =>    l_pos_ei_data.poei_information3
                        , p_poei_information5        =>    to_char(l_essl_tab_id));

Line: 373

                           l_log_text := substr(l_log_text || ', Message : ' || 'Record Inserted',1,2000);

Line: 376

                        ghr_validate_perwsdpo.update_posn_status(l_position_id,l_effective_date);

Line: 387

                           l_log_text := substr(l_log_text || ', Message : ' || 'Record Not Inserted',1,2000);

Line: 430

	  	  UPDATE GHR_PA_HISTORY
		  SET    information11 = to_char(l_essl_tab_id)
		  WHERE  pa_history_id = l_hist_id;

Line: 435

                       l_log_text := substr(l_log_text || ', Message        : ' || 'ERROR NOT UPDATED ,',1,2000);

Line: 443

                       l_log_text := substr(l_log_text || ', Message        : ' || 'Updated Successful ',1,2000);

Line: 461

                    p_log_text     => 'Error : NO Valid History Position Records found for Update',
                    p_log_date     => sysdate);

Line: 467

                    p_log_text     => 'Total Records inserted with SES equivalent plans are ' ||
                    to_char(l_counter1) || ' and Updates are ' || to_char(l_counter),
                    p_log_date     => sysdate);