APPS.GHR_COMPL_AGENCY_COSTS_PKG dependencies on GHR_COMPL_CA_HEADERS

Line 140: FROM ghr_compl_ca_details cad, ghr_compl_ca_headers cah

136: WHERE complaint_id = p_complaint_id;
137:
138: CURSOR cur_benefits_received IS
139: SELECT nvl(sum(cad.amount),0) amount
140: FROM ghr_compl_ca_details cad, ghr_compl_ca_headers cah
141: WHERE cah.complaint_id = p_complaint_id
142: AND cah.compl_ca_header_id = cad.compl_ca_header_id;
143:
144: BEGIN