DBA Data[Home] [Help]

APPS.IGW_OVERHEAD_CAL dependencies on IGW_PROP_RATES

Line 155: from igw_prop_rates

151:
152: begin
153: select applicable_rate, start_date
154: into x_rate_ov, x_start_date
155: from igw_prop_rates
156: where rate_class_id = p_rate_class_id
157: and rate_type_id = p_rate_type_id
158: and activity_type_code = p_activity_type_code
159: and location_code = p_location_code

Line 207: from igw_prop_rates

203: l_applicable_rate number(15);
204: begin
205: select applicable_rate
206: into l_applicable_rate
207: from igw_prop_rates
208: where proposal_id = p_proposal_id
209: and version_id = p_version_id
210: and rate_class_id = p_rate_class_id
211: and rate_type_id = p_rate_type_id

Line 972: from igw_prop_rates

968:
969: begin
970: select applicable_rate
971: into l_inflation_rate_ov
972: from igw_prop_rates
973: where rate_class_id = l_rate_class_id_inf
974: and rate_type_id = l_rate_type_id_inf
975: and activity_type_code = p_activity_type_code
976: and location_code = p_location_code