APPS.IGW_OVERHEAD_CAL dependencies on IGW_INSTITUTE_RATES

Line 142: from igw_institute_rates ir

138:
139: begin
140: select rate,start_date
141: into x_rate, x_start_date
142: from igw_institute_rates ir
143: where ir.rate_class_id = p_rate_class_id
144: and ir.rate_type_id = p_rate_type_id
145: and ir.activity_type_code = p_activity_type_code
146: and ir.location_code = p_location_code

Line 754: from igw_institute_rates ir

750: l_msg_data VARCHAR2(200);
751:
752: cursor c_inf_rates is
753: select rate,start_date, fiscal_year
754: from igw_institute_rates ir
755: where ir.rate_class_id = l_rate_class_id_inf
756: and ir.rate_type_id = l_rate_type_id_inf
757: and ir.activity_type_code = p_activity_type_code
758: and ir.location_code = p_location_code