DBA Data[Home] [Help]

APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_QP_DISCOUNTS

Line 60: FROM ozf_qp_discounts

56: AND offer_market_option_id = p_offer_market_option_id;
57: -- above cursors can be combined. offer_id is not needed as qp_list_header_id is present in table
58: CURSOR c_pbh_line_id IS
59: SELECT offer_discount_line_id
60: FROM ozf_qp_discounts
61: WHERE list_line_id = p_list_line_id;
62:
63: CURSOR c_existing_values(p_indirect_flag VARCHAR2,l_order_line_id NUMBER) IS
64: SELECT group_no, volume_track_type, combine_schedule_yn, pbh_line_id, prod_attribute, prod_attr_value