APPS.OZF_OFFER_ADJ_LINE_PVT dependencies on OZF_VOLUME_OFFER_TIERS

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

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

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

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