APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 134: FROM ozf_offer_adjustments_b a, ozf_offers b , qp_list_lines c , qp_list_headers_b d

130: ) endDate
131: --greatest(nvl(d.start_date_active, a.effective_date - 5 ),nvl(d.start_date_active, a.effective_date - 5 ), a.effective_date - 1 ) endDate
132: , b.offer_type, b.qp_list_header_id
133: , c.start_date_active lineStartDate, d.start_date_active headerStartDate, a.effective_date adjEffectiveDate, b.custom_setup_id
134: FROM ozf_offer_adjustments_b a, ozf_offers b , qp_list_lines c , qp_list_headers_b d
135: WHERE
136: a.list_header_id = b.qp_list_header_id
137: AND b.qp_list_header_id = c.list_header_id
138: AND c.list_header_id = d.list_header_id

Line 631: FROM ozf_offer_adjustments_b a

627: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)
628: IS
629: SELECT
630: a.effective_date, a.list_header_id
631: FROM ozf_offer_adjustments_b a
632: WHERE a.offer_adjustment_id = cp_offerAdjustmentId;
633: l_additionalDetails c_additionalDetails%ROWTYPE;
634: BEGIN
635: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1359: ozf_offer_discount_lines a, ozf_offers b , ozf_offer_adjustments_b c , ozf_offer_discount_lines d

1355: , a.formula_id
1356: , a.discount
1357: , c.effective_date
1358: FROM
1359: ozf_offer_discount_lines a, ozf_offers b , ozf_offer_adjustments_b c , ozf_offer_discount_lines d
1360: WHERE
1361: a.offer_discount_line_id = cp_offerDiscountLineId
1362: AND a.offer_id = b.offer_id
1363: AND b.qp_list_header_id = c.list_header_id

Line 1957: FROM ozf_offer_adjustments_b

1953: IS
1954: CURSOR c_adjDetails(cp_offerAdjustmentId NUMBER) IS
1955: SELECT
1956: effective_date
1957: FROM ozf_offer_adjustments_b
1958: WHERE offer_adjustment_id = cp_offerAdjustmentId;
1959: l_adjDetails c_adjDetails%ROWTYPE;
1960: BEGIN
1961: x_return_status := FND_API.G_RET_STS_SUCCESS;