APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_OFFERS

Line 229: FROM ozf_offers

225: AND order_line_id = p_line_id;
226:
227: CURSOR c_currency_code(p_offer_id NUMBER) IS
228: SELECT NVL(transaction_currency_code, fund_request_curr_code)
229: FROM ozf_offers
230: WHERE offer_id = p_offer_id;
231:
232: CURSOR c_order_line_type(p_line_id NUMBER) IS
233: SELECT reference_header_id, reference_line_id, line_category_code, return_context, return_attribute1, return_attribute2

Line 1058: FROM ozf_offers off, ozf_funds_utilized_all_b utl

1054: )
1055: IS
1056: CURSOR c_offer_id_om(p_order_line_id NUMBER, p_object_type VARCHAR2) IS
1057: SELECT off.offer_id, off.qp_list_header_id
1058: FROM ozf_offers off, ozf_funds_utilized_all_b utl
1059: WHERE off.qp_list_header_id = utl.plan_id
1060: AND off.offer_type = 'VOLUME_OFFER'
1061: AND utl.plan_type = 'OFFR'
1062: AND utl.order_line_id = p_order_line_id

Line 1074: FROM ozf_offers off, ozf_funds_utilized_all_b utl

1070: AND utl.object_type = p_object_type;
1071:
1072: CURSOR c_offer_id_is(p_order_line_id NUMBER, p_object_type VARCHAR2) IS
1073: SELECT off.offer_id, off.qp_list_header_id
1074: FROM ozf_offers off, ozf_funds_utilized_all_b utl
1075: WHERE off.qp_list_header_id = utl.plan_id
1076: AND off.offer_type = 'VOLUME_OFFER'
1077: AND utl.plan_type = 'OFFR'
1078: AND utl.object_id = p_order_line_id

Line 1086: FROM ozf_offers

1082: AND utl.object_type = p_object_type;
1083:
1084: CURSOR c_offer_id IS
1085: SELECT offer_id, qp_list_header_id
1086: FROM ozf_offers
1087: WHERE offer_type = 'VOLUME_OFFER'
1088: AND qp_list_header_id = p_qp_list_header_id;
1089:
1090: -- Catch Weight ER - start

Line 1581: FROM ozf_offers

1577: AND volume_detail_id <= p_volume_detail_id;
1578:
1579: CURSOR c_volume_offer_type IS
1580: SELECT volume_offer_type
1581: FROM ozf_offers
1582: WHERE offer_id = p_offer_id;
1583:
1584: l_volume_offer_type VARCHAR2(30);
1585: l_volume_b4_trx_date NUMBER;

Line 1950: FROM ozf_offers o, qp_list_lines q

1946: )
1947: RETURN NUMBER IS
1948: CURSOR c_offer_id IS
1949: SELECT o.qp_list_header_id, o.offer_id
1950: FROM ozf_offers o, qp_list_lines q
1951: WHERE o.qp_list_header_id = q.list_header_id
1952: AND q.list_line_id = p_list_line_id;
1953:
1954: CURSOR c_order_detail IS

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

2586: l_payout_accrual NUMBER;
2587: l_qp_list_header_id NUMBER;
2588: BEGIN
2589:
2590: select qp_list_header_id into l_qp_list_header_id from ozf_offers where offer_id = p_offer_id;
2591:
2592: -- fixed bug 12887627
2593: SELECT SUM(uti.plan_curr_amount) into l_payout_accrual
2594: FROM ozf_funds_utilized_all_b uti