APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_OFFER_DISCOUNT_LINES

Line 4045: FROM ozf_offer_discount_lines

4041: WHERE qp_list_header_id = p_qp_list_header_id;
4042:
4043: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
4044: SELECT discount_type,volume_type
4045: FROM ozf_offer_discount_lines
4046: WHERE offer_discount_line_id = p_discount_line_id
4047: AND tier_type = 'PBH';
4048:
4049: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS

Line 4063: FROM ozf_offer_discount_lines

4059: AND opt.qp_list_header_id = p_list_header_id;
4060:
4061: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS
4062: SELECT discount
4063: FROM ozf_offer_discount_lines
4064: WHERE p_volume > volume_from
4065: AND p_volume <= volume_to
4066: AND parent_discount_line_id = p_parent_discount_id;
4067:

Line 4070: FROM ozf_offer_discount_lines

4066: AND parent_discount_line_id = p_parent_discount_id;
4067:
4068: CURSOR c_get_tier_limits (p_parent_discount_id IN NUMBER) IS
4069: SELECT MIN(volume_from),MAX(volume_to)
4070: FROM ozf_offer_discount_lines
4071: WHERE parent_discount_line_id = p_parent_discount_id;
4072:
4073: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
4074: SELECT discount

Line 4075: FROM ozf_offer_discount_lines

4071: WHERE parent_discount_line_id = p_parent_discount_id;
4072:
4073: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
4074: SELECT discount
4075: FROM ozf_offer_discount_lines
4076: WHERE volume_to =p_max_volume_to
4077: AND parent_discount_line_id = p_parent_discount_id;
4078:
4079: CURSOR c_discount(p_order_line_id IN NUMBER) IS