APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_OFFER_DISCOUNT_LINES

Line 3151: FROM ozf_offer_discount_lines

3147: WHERE qp_list_header_id = p_offer_id;
3148:
3149: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
3150: SELECT discount_type,volume_type
3151: FROM ozf_offer_discount_lines
3152: WHERE offer_discount_line_id = p_discount_line_id
3153: AND tier_type = 'PBH';
3154:
3155: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS

Line 3169: FROM ozf_offer_discount_lines

3165: AND opt.qp_list_header_id = p_list_header_id;
3166:
3167: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS
3168: SELECT discount
3169: FROM ozf_offer_discount_lines
3170: WHERE p_volume > volume_from
3171: AND p_volume <= volume_to
3172: AND parent_discount_line_id = p_parent_discount_id;
3173:

Line 3176: FROM ozf_offer_discount_lines

3172: AND parent_discount_line_id = p_parent_discount_id;
3173:
3174: CURSOR c_get_tier_limits (p_parent_discount_id IN NUMBER) IS
3175: SELECT MIN(volume_from),MAX(volume_to)
3176: FROM ozf_offer_discount_lines
3177: WHERE parent_discount_line_id = p_parent_discount_id;
3178:
3179: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
3180: SELECT discount

Line 3181: FROM ozf_offer_discount_lines

3177: WHERE parent_discount_line_id = p_parent_discount_id;
3178:
3179: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
3180: SELECT discount
3181: FROM ozf_offer_discount_lines
3182: WHERE volume_to =p_max_volume_to
3183: AND parent_discount_line_id = p_parent_discount_id;
3184:
3185: CURSOR c_discount(p_order_line_id IN NUMBER) IS