APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_OFFER_ADJUSTMENTS_B

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

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

Line 576: FROM ozf_offer_adjustments_b a

572: CURSOR c_additionalDetails(cp_offerAdjustmentId NUMBER)
573: IS
574: SELECT
575: a.effective_date, a.list_header_id
576: FROM ozf_offer_adjustments_b a
577: WHERE a.offer_adjustment_id = cp_offerAdjustmentId;
578: l_additionalDetails c_additionalDetails%ROWTYPE;
579: BEGIN
580: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1300: , a.formula_id
1301: , a.discount
1302: , c.effective_date
1303: FROM
1304: ozf_offer_discount_lines a, ozf_offers b , ozf_offer_adjustments_b c , ozf_offer_discount_lines d
1305: WHERE
1306: a.offer_discount_line_id = cp_offerDiscountLineId
1307: AND a.offer_id = b.offer_id
1308: AND b.qp_list_header_id = c.list_header_id

Line 1898: FROM ozf_offer_adjustments_b

1894: IS
1895: CURSOR c_adjDetails(cp_offerAdjustmentId NUMBER) IS
1896: SELECT
1897: effective_date
1898: FROM ozf_offer_adjustments_b
1899: WHERE offer_adjustment_id = cp_offerAdjustmentId;
1900: l_adjDetails c_adjDetails%ROWTYPE;
1901: BEGIN
1902: x_return_status := FND_API.G_RET_STS_SUCCESS;