APPS.GHR_EEOC_DYNAMICS_REPORT SQL Statements

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

Line: 26

    SELECT par.*, per.full_name, per.employee_number
    FROM   ghr_pa_requests par,
           per_all_people_f    per
    WHERE  NVL(par.agency_code,par.from_agency_code) LIKE p_agency_code||NVL(p_agency_sub_code,'%')
    AND    par.person_id = per.person_id
    AND    trunc(par.effective_date) BETWEEN p_report_st_dt AND p_report_end_dt
    AND    trunc(par.effective_date) BETWEEN per.effective_start_date AND per.effective_end_date
    AND    par.status IN ('UPDATE_HR_COMPLETE')
    AND    Exclude_Noac(par.first_noa_code) <> 'TRUE'
     -- Bug # 12862346
    AND    NOT EXISTS (select 1
                       from  ghr_pa_requests b
                       where altered_pa_request_id = par.pa_request_id
                       and   pa_notification_id is not null
                       and   first_noa_code = '001'
                       and   second_noa_code = par.first_noa_code)
    AND    decode(hr_general.get_xbg_profile,'Y',per.business_group_id ,p_business_group) = per.business_group_id;

Line: 46

    select award_amount
    from   ghr_pa_requests
    where  first_noa_code = '002'
    and    pa_notification_id is not null
    connect by prior pa_request_id   = altered_pa_request_id
    start with altered_pa_request_id = p_pa_request_id
    order by pa_notification_id desc;

Line: 106

      insert_row;

Line: 108

      hr_utility.set_location('After Insert Row',1000);

Line: 147

PROCEDURE Insert_Row IS
l_proc           varchar2(30) := 'insert_row';

Line: 155

   INSERT INTO ghr_cpdf_temp(report_type
                            ,session_id
                            ,agency_code
                            ,effective_date
			    ,from_national_identifier
                            ,ehri_employee_id
                            ,first_noa_code
                            ,award_dollars
			    ,award_hours)
                    values (
		            'EEOCDYNAMICS'
		           ,userenv('SESSIONID')
		           ,g_temp_rec.agency_code
		           ,g_temp_rec.effective_date
  		           ,g_temp_rec.from_national_identifier
		           ,g_temp_rec.ehri_employee_id
                           ,g_temp_rec.first_noa_code
			   ,g_temp_rec.award_dollars
			   ,g_temp_rec.award_hours);

Line: 178

           l_log_text     := 'Unhandled Error under procedure insert_row'||
                             ';  ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line: 184

  END Insert_Row;

Line: 209

 SELECT  *
 FROM    GHR_CPDF_TEMP
 WHERE   SESSION_ID  = c_session_id
 AND     REPORT_TYPE = 'EEOCDYNAMICS'
 ORDER BY AGENCY_CODE,TO_NATIONAL_IDENTIFIER,EFFECTIVE_DATE;

Line: 217

  SELECT value
  FROM   V$PARAMETER
  WHERE  NAME = 'utl_file_dir';