APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_OFFERS

Line 198: FROM ozf_offers

194: AND order_line_id = p_line_id;
195:
196: CURSOR c_currency_code(p_offer_id NUMBER) IS
197: SELECT NVL(transaction_currency_code, fund_request_curr_code)
198: FROM ozf_offers
199: WHERE offer_id = p_offer_id;
200:
201: CURSOR c_order_line_type(p_line_id NUMBER) IS
202: SELECT reference_header_id, reference_line_id, line_category_code, return_context, return_attribute1, return_attribute2

Line 759: FROM ozf_offers off, ozf_funds_utilized_all_b utl

755: )
756: IS
757: CURSOR c_offer_id_om(p_order_line_id NUMBER, p_object_type VARCHAR2) IS
758: SELECT off.offer_id, off.qp_list_header_id
759: FROM ozf_offers off, ozf_funds_utilized_all_b utl
760: WHERE off.qp_list_header_id = utl.plan_id
761: AND off.offer_type = 'VOLUME_OFFER'
762: AND utl.plan_type = 'OFFR'
763: AND utl.order_line_id = p_order_line_id

Line 775: FROM ozf_offers off, ozf_funds_utilized_all_b utl

771: AND utl.object_type = p_object_type;
772:
773: CURSOR c_offer_id_is(p_order_line_id NUMBER, p_object_type VARCHAR2) IS
774: SELECT off.offer_id, off.qp_list_header_id
775: FROM ozf_offers off, ozf_funds_utilized_all_b utl
776: WHERE off.qp_list_header_id = utl.plan_id
777: AND off.offer_type = 'VOLUME_OFFER'
778: AND utl.plan_type = 'OFFR'
779: AND utl.object_id = p_order_line_id

Line 787: FROM ozf_offers

783: AND utl.object_type = p_object_type;
784:
785: CURSOR c_offer_id IS
786: SELECT offer_id, qp_list_header_id
787: FROM ozf_offers
788: WHERE offer_type = 'VOLUME_OFFER'
789: AND qp_list_header_id = p_qp_list_header_id;
790:
791: l_offer_id NUMBER;

Line 1151: FROM ozf_offers

1147: AND volume_detail_id <= p_volume_detail_id;
1148:
1149: CURSOR c_volume_offer_type IS
1150: SELECT volume_offer_type
1151: FROM ozf_offers
1152: WHERE offer_id = p_offer_id;
1153:
1154: l_volume_offer_type VARCHAR2(30);
1155: l_volume_b4_trx_date NUMBER;

Line 1520: FROM ozf_offers o, qp_list_lines q

1516: )
1517: RETURN NUMBER IS
1518: CURSOR c_offer_id IS
1519: SELECT o.qp_list_header_id, o.offer_id
1520: FROM ozf_offers o, qp_list_lines q
1521: WHERE o.qp_list_header_id = q.list_header_id
1522: AND q.list_line_id = p_list_line_id;
1523:
1524: CURSOR c_order_detail IS

Line 2130: select qp_list_header_id into l_qp_list_header_id from ozf_offers where offer_id = p_offer_id;

2126: l_payout_accrual NUMBER;
2127: l_qp_list_header_id NUMBER;
2128: BEGIN
2129:
2130: select qp_list_header_id into l_qp_list_header_id from ozf_offers where offer_id = p_offer_id;
2131:
2132: SELECT SUM(uti.plan_curr_amount) into l_payout_accrual
2133: FROM ozf_funds_utilized_all_b uti
2134: WHERE uti.utilization_type IN ('UTILIZED','ACCRUAL','ADJUSTMENT','CHARGEBACK','LEAD_ACCRUAL')