DBA Data[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_VOLUME_OFFER_TIERS

Line 3547: FROM ozf_volume_offer_tiers

3543: CURSOR c_current_discount (p_list_header_id IN NUMBER,
3544: p_order_amount IN NUMBER) IS
3545: SELECT discount,
3546: discount_type_code
3547: FROM ozf_volume_offer_tiers
3548: WHERE p_order_amount BETWEEN
3549: tier_value_from AND tier_value_to
3550: AND qp_list_header_id = p_list_header_id;
3551: */

Line 3560: FROM ozf_volume_offer_tiers tier

3556: WHERE list_header_id = p_list_header_id;
3557:
3558: CURSOR c_volume_type (p_list_header_id IN NUMBER) IS
3559: SELECT distinct volume_type
3560: FROM ozf_volume_offer_tiers tier
3561: WHERE qp_list_header_id = p_list_header_id;
3562:
3563: CURSOR c_offer_curr IS
3564: SELECT nvl(transaction_currency_code,fund_request_curr_code)