APPS.GHR_MASS_CHANGES SQL Statements

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

Line: 92

  select 1 from pay_user_tables
  where substr(user_table_name,1,4) = 'ESSL'
  and user_table_id = l_user_table_id;

Line: 101

  select userenv('sessionid') sesid  from dual;

Line: 104

    select NOA_FAMILY_CODE
    from ghr_families
    where NOA_FAMILY_CODE in
        (select NOA_FAMILY_CODE from ghr_noa_families
             where  nature_of_action_id =
                (select nature_of_action_id
                 from ghr_nature_of_actions
                 where code = '894')
        ) and proc_method_flag = 'Y';

Line: 115

    select prh.pa_routing_history_id,
           prh.object_version_number
    from   ghr_pa_routing_history prh
    where  prh.pa_request_id  =  l_pa_request_rec.pa_request_id
    order  by  1 desc;

Line: 123

    select NOA_FAMILY_CODE
    from ghr_families
    where NOA_FAMILY_CODE in
       (select NOA_FAMILY_CODE from ghr_noa_families
        where  nature_of_action_id =
            (select nature_of_action_id
             from ghr_nature_of_actions
             where code = nvl(ghr_msl_pkg.g_first_noa_code,'894') and  p_effective_date between date_from and nvl(date_to,p_effective_date))
        ) and proc_method_flag = 'Y';

Line: 149

      update fnd_sessions set SESSION_ID = l_sid
      where  SESSION_ID = l_sid;

Line: 152

         INSERT INTO fnd_sessions
            (SESSION_ID,EFFECTIVE_DATE)
         VALUES
            (l_sid,sysdate);

Line: 254

          ghr_mass_actions_pkg.replace_insertion_values
	    (p_desc                => l_pa_request_rec.first_noa_desc,
	     p_information1        => l_pa_request_rec.first_noa_information1,
	     p_desc_out            => l_desc_out
	    );

Line: 931

    ghr_sf52_post_update.get_notification_details(
        p_pa_request_id           =>  l_pa_request_rec.pa_request_id,
        p_effective_date          =>  l_pa_request_rec.effective_date,
        p_from_position_id        =>  l_pa_request_rec.from_position_id,
        p_to_position_id          =>  l_pa_request_rec.to_position_id,
        p_agency_code             =>  l_pa_request_rec.agency_code,
        p_from_agency_code        =>  l_pa_request_rec.from_agency_code,
        p_from_agency_desc        =>  l_pa_request_rec.from_agency_desc,
        p_from_office_symbol      =>  l_pa_request_rec.from_office_symbol,
        p_personnel_office_id     =>  l_pa_request_rec.personnel_office_id,
        p_employee_dept_or_agency =>  l_pa_request_rec.employee_dept_or_agency,
        p_to_office_symbol        =>  l_pa_request_rec.to_office_symbol);

Line: 996

       l_log_text   := 'Error while create / Update the PA Request Rec. ';

Line: 1016

       l_log_text   := 'Error while create / Update the PA Request Rec. ';

Line: 1090

    ghr_mass_actions_pkg.replace_insertion_values
    (p_desc                => l_description,
     p_information1        => l_remark_code_information1,
     p_information2        => l_remark_code_information2,
     p_information3        => l_remark_code_information3,
     p_information4        => l_remark_code_information4,
     p_information5        => l_remark_code_information5,
     p_desc_out            => l_description_out
    );