DBA Data[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_VOLUME_OFFER_TIERS

Line 7586: FROM ozf_volume_offer_tiers

7582: CURSOR c_current_discount (p_list_header_id IN NUMBER,
7583: p_order_amount IN NUMBER) IS
7584: SELECT discount,
7585: discount_type_code
7586: FROM ozf_volume_offer_tiers
7587: WHERE p_order_amount BETWEEN
7588: tier_value_from AND tier_value_to
7589: AND qp_list_header_id = p_list_header_id;
7590: */

Line 7599: FROM ozf_volume_offer_tiers tier

7595: WHERE list_header_id = p_list_header_id;
7596:
7597: CURSOR c_volume_type (p_list_header_id IN NUMBER) IS
7598: SELECT distinct volume_type
7599: FROM ozf_volume_offer_tiers tier
7600: WHERE qp_list_header_id = p_list_header_id;
7601:
7602: CURSOR c_offer_curr IS
7603: SELECT nvl(transaction_currency_code,fund_request_curr_code)