eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_COMPL_AGENCY_COSTS_PKG SQL Statements

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

Line: 20


  SELECT cac.amount
  FROM   ghr_compl_agency_costs cac
  WHERE  cac.complaint_id = p_complaint_id
  AND    cac.phase like decode(p_phase,'999','%',p_phase);

Line: 26


  SELECT cac.amount
  FROM   ghr_compl_agency_costs cac
  WHERE  cac.complaint_id = p_complaint_id
  AND    cac.phase like decode(p_phase,'999','%',p_phase)
  AND    cac.stage like decode(p_stage,'999','%',p_stage);

Line: 33


  SELECT cac.amount
  FROM   ghr_compl_agency_costs cac
  WHERE  cac.complaint_id = p_complaint_id
  AND    cac.phase like decode(p_phase,'999','%',p_phase)
  AND    cac.stage like decode(p_stage,'999','%',p_stage)
  AND    nvl(cac.category,'%') like decode(p_category,'999','%',p_category);

Line: 102


  SELECT sum(decode(phase,'10',decode(stage,'GHR_US_INFO_INQUIRY_COSTS',amount,0),0)) info_inquiry_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_INFO_INQUIRY_COSTS',amount,0),0)) info_inquiry_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_INFO_INQUIRY_COSTS',amount,0),0)) info_inquiry_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_PRE_COMPL_COSTS',amount,0),0)) pre_complaint_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_PRE_COMPL_COSTS',amount,0),0)) pre_complaint_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_PRE_COMPL_COSTS',amount,0),0)) pre_complaint_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_FORMAL_COMPL_COSTS',amount,0),0)) formal_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_FORMAL_COMPL_COSTS',amount,0),0)) formal_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_FORMAL_COMPL_COSTS',amount,0),0)) formal_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_INVESTIGATION_COSTS',amount,0),0)) investigation_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_INVESTIGATION_COSTS',amount,0),0)) investigation_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_INVESTIGATION_COSTS',amount,0),0)) investigation_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_HEARING_COMPL_COSTS',amount,0),0)) hearing_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_HEARING_COMPL_COSTS',amount,0),0)) hearing_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_HEARING_COMPL_COSTS',amount,0),0)) hearing_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_FAD_COSTS',amount,0),0)) fad_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_FAD_COSTS',amount,0),0)) fad_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_FAD_COSTS',amount,0),0)) fad_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_FAA_COSTS',amount,0),0)) faa_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_FAA_COSTS',amount,0),0)) faa_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_FAA_COSTS',amount,0),0)) faa_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_APPELLATE_COSTS',amount,0),0)) appellate_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_APPELLATE_COSTS',amount,0),0)) appellate_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_APPELLATE_COSTS',amount,0),0)) appellate_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_CIVIL_ACTION_COSTS',amount,0),0)) civil_action_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_CIVIL_ACTION_COSTS',amount,0),0)) civil_action_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_CIVIL_ACTION_COSTS',amount,0),0)) civil_action_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_OTHER_COSTS',amount,0),0)) other_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_OTHER_COSTS',amount,0),0)) other_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_OTHER_COSTS',amount,0),0)) other_formal,
         sum(decode(phase,'10',decode(stage,'GHR_US_AMENDMENT_COSTS',amount,0),0)) amendment_info,
         sum(decode(phase,'20',decode(stage,'GHR_US_AMENDMENT_COSTS',amount,0),0)) amendment_pre,
         sum(decode(phase,'30',decode(stage,'GHR_US_AMENDMENT_COSTS',amount,0),0)) amendment_formal
  FROM   ghr_compl_agency_costs
  WHERE  complaint_id = p_complaint_id;

Line: 139


  SELECT nvl(sum(cad.amount),0) amount
  FROM   ghr_compl_ca_details cad, ghr_compl_ca_headers cah
  WHERE  cah.complaint_id = p_complaint_id
  AND    cah.compl_ca_header_id = cad.compl_ca_header_id;