APPS.GHR_COMPL_AGENCY_COSTS_PKG dependencies on GHR_COMPL_AGENCY_COSTS

Line 1: PACKAGE BODY ghr_compl_agency_costs_pkg AS

1: PACKAGE BODY ghr_compl_agency_costs_pkg AS
2: /* $Header: ghcstpkg.pkb 120.0 2005/05/29 03:05:17 appldev noship $ */
3:
4: -- Get Cost Entry Screen Totals
5: PROCEDURE get_entry_totals (p_complaint_id IN NUMBER

Line 21: FROM ghr_compl_agency_costs cac

17:
18:
19: CURSOR cur_phase_costs IS
20: SELECT cac.amount
21: FROM ghr_compl_agency_costs cac
22: WHERE cac.complaint_id = p_complaint_id
23: AND cac.phase like decode(p_phase,'999','%',p_phase);
24:
25: CURSOR cur_stage_costs IS

Line 27: FROM ghr_compl_agency_costs cac

23: AND cac.phase like decode(p_phase,'999','%',p_phase);
24:
25: CURSOR cur_stage_costs IS
26: SELECT cac.amount
27: FROM ghr_compl_agency_costs cac
28: WHERE cac.complaint_id = p_complaint_id
29: AND cac.phase like decode(p_phase,'999','%',p_phase)
30: AND cac.stage like decode(p_stage,'999','%',p_stage);
31:

Line 34: FROM ghr_compl_agency_costs cac

30: AND cac.stage like decode(p_stage,'999','%',p_stage);
31:
32: CURSOR cur_category_costs IS
33: SELECT cac.amount
34: FROM ghr_compl_agency_costs cac
35: WHERE cac.complaint_id = p_complaint_id
36: AND cac.phase like decode(p_phase,'999','%',p_phase)
37: AND cac.stage like decode(p_stage,'999','%',p_stage)
38: AND nvl(cac.category,'%') like decode(p_category,'999','%',p_category);

Line 135: FROM ghr_compl_agency_costs

131: sum(decode(phase,'30',decode(stage,'GHR_US_OTHER_COSTS',amount,0),0)) other_formal,
132: sum(decode(phase,'10',decode(stage,'GHR_US_AMENDMENT_COSTS',amount,0),0)) amendment_info,
133: sum(decode(phase,'20',decode(stage,'GHR_US_AMENDMENT_COSTS',amount,0),0)) amendment_pre,
134: sum(decode(phase,'30',decode(stage,'GHR_US_AMENDMENT_COSTS',amount,0),0)) amendment_formal
135: FROM ghr_compl_agency_costs
136: WHERE complaint_id = p_complaint_id;
137:
138: CURSOR cur_benefits_received IS
139: SELECT nvl(sum(cad.amount),0) amount

Line 192: END ghr_compl_agency_costs_pkg;

188: null;
189: END get_summary_totals;
190:
191:
192: END ghr_compl_agency_costs_pkg;