APPS.OZF_OFFER_ADJ_LINE_PVT dependencies on OZF_VOLUME_OFFER_TIERS

Line 102: SELECT discount , discount_type_code , uom_code , volume_type , tier_value_from , active,tier_value_to FROM ozf_volume_offer_tiers

98: PROCEDURE populate_volume_offer(p_list_line_rec IN offadj_new_line_rec_type,
99: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )
100: IS
101: CURSOR c_tier_data (p_list_header_id NUMBER) IS
102: SELECT discount , discount_type_code , uom_code , volume_type , tier_value_from , active,tier_value_to FROM ozf_volume_offer_tiers
103: WHERE qp_list_header_id = p_list_header_id
104: AND tier_value_from = (SELECT min(tier_value_from) FROM ozf_volume_offer_tiers WHERE qp_list_header_id = p_list_header_id ) ;
105:
106: l_tier_data c_tier_data%rowtype;

Line 104: AND tier_value_from = (SELECT min(tier_value_from) FROM ozf_volume_offer_tiers WHERE qp_list_header_id = p_list_header_id ) ;

100: IS
101: CURSOR c_tier_data (p_list_header_id NUMBER) IS
102: SELECT discount , discount_type_code , uom_code , volume_type , tier_value_from , active,tier_value_to FROM ozf_volume_offer_tiers
103: WHERE qp_list_header_id = p_list_header_id
104: AND tier_value_from = (SELECT min(tier_value_from) FROM ozf_volume_offer_tiers WHERE qp_list_header_id = p_list_header_id ) ;
105:
106: l_tier_data c_tier_data%rowtype;
107:
108: BEGIN