APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_OFFERS

Line 225: FROM ozf_offers

221:
222: -- cursor for accrual budget
223: CURSOR c_offer_info IS
224: SELECT NVL(budget_offer_yn,'N')
225: FROM ozf_offers
226: WHERE qp_list_header_id = p_src_id;
227: -- cursor for accrual fund
228: CURSOR c_fund IS
229: SELECT fund_id , currency_code_tc

Line 550: FROM ozf_offers

546: WHERE org_id = p_org_id;
547:
548: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
549: SELECT nvl(transaction_currency_code,fund_request_curr_code) offer_currency_code
550: FROM ozf_offers
551: WHERE qp_list_header_id = p_offer_id;
552:
553: -- nepanda Fix for bug 12911854
554: l_fc_currency_code VARCHAR2(150);

Line 969: FROM ozf_offers

965: SELECT offer_type, custom_setup_id, beneficiary_account_id,
966: nvl(transaction_currency_code,fund_request_curr_code) offer_currency_code,
967: transaction_currency_code,
968: offer_id,autopay_party_attr,autopay_party_id --nirprasa
969: FROM ozf_offers
970: WHERE qp_list_header_id = p_offer_id;
971:
972: CURSOR c_accrual_flag (p_price_adjustment_id IN NUMBER) IS
973: SELECT NVL(accrual_flag,'N')

Line 2247: FROM qp_list_headers_all qp, ozf_offers off

2243:
2244: --nirprasa,ER 8399134
2245: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
2246: SELECT qp.orig_org_id offer_org_id
2247: FROM qp_list_headers_all qp, ozf_offers off
2248: WHERE qp.list_header_id = p_list_header_id
2249: AND qp.list_header_id = off.qp_list_header_id;
2250:
2251: l_offer_info c_offer_info%ROWTYPE;

Line 2445: FROM ozf_offers

2441:
2442: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
2443: SELECT beneficiary_account_id,
2444: autopay_party_attr,autopay_party_id,transaction_currency_code
2445: FROM ozf_offers
2446: WHERE qp_list_header_id = p_offer_id;
2447:
2448: --Added for bug 7030415, get conversion type
2449: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS

Line 2918: FROM ozf_offers

2914: CURSOR c_tm_offer (p_list_header_id IN NUMBER) IS
2915: --SELECT nvl(transaction_currency_code,fund_request_curr_code) transaction_currency_code
2916: SELECT nvl(transaction_currency_code,fund_request_curr_code) offer_currency_code,
2917: transaction_currency_code
2918: FROM ozf_offers
2919: WHERE qp_list_header_id = p_list_header_id;
2920:
2921: CURSOR c_get_util (p_list_header_id IN NUMBER, p_header_id IN NUMBER, p_line_id IN NUMBER) IS
2922: SELECT 1

Line 2947: FROM ozf_offers off, qp_list_headers_all qp

2943: WHERE org_id = p_org_id;
2944:
2945: CURSOR c_offer_details(p_qp_list_header_id NUMBER) IS
2946: SELECT custom_setup_id, description
2947: FROM ozf_offers off, qp_list_headers_all qp
2948: WHERE off.qp_list_header_id = p_qp_list_header_id
2949: AND off.qp_list_header_id = qp.list_header_id;
2950:
2951: CURSOR c_is_parent_line (p_line_id IN NUMBER) IS

Line 3989: FROM ozf_offers

3985: --kdass bug 5953774
3986: CURSOR c_offer_currency (p_list_header_id IN NUMBER) IS
3987: SELECT nvl(transaction_currency_code, fund_request_curr_code) offer_currency,
3988: transaction_currency_code
3989: FROM ozf_offers
3990: WHERE qp_list_header_id = p_list_header_id;
3991:
3992:
3993:

Line 4040: FROM ozf_offers

4036: WHERE order_line_id = p_line_id;
4037:
4038: CURSOR c_offer_details (p_qp_list_header_id IN NUMBER) IS
4039: SELECT custom_setup_id
4040: FROM ozf_offers
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

Line 5713: ozf_offers off, oe_price_adjustments oe,

5709: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0)) ShippedQuantity,
5710: (NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0))*line.unit_selling_price) Revenue,
5711: NVL(util.plan_curr_amount,0) AccrualAmount
5712: FROM oe_order_lines_all line, ozf_funds_utilized_all_b util,
5713: ozf_offers off, oe_price_adjustments oe,
5714: ozf_xref_map map
5715: WHERE line.line_id = util.order_line_id
5716: AND line.header_id = util.object_id
5717: AND util.object_type = ''ORDER''

Line 5741: ozf_offers off, oe_price_adjustments oe,

5737: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0)) ShippedQuantity,
5738: (NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0))*line.unit_selling_price) Revenue,
5739: NVL(util.plan_curr_amount,0) AccrualAmount
5740: FROM oe_order_lines_all line, ozf_funds_utilized_all_b util,
5741: ozf_offers off, oe_price_adjustments oe,
5742: ozf_xref_map map
5743: WHERE line.line_id = util.order_line_id
5744: AND line.header_id = util.object_id
5745: AND util.object_type = ''ORDER''

Line 5834: FROM ozf_offers a, ozf_funds_utilized_all_b b

5830: l_offer_type varchar2(30);
5831:
5832: CURSOR c_get_offer_type(p_util_id IN NUMBER) IS
5833: SELECT offer_type
5834: FROM ozf_offers a, ozf_funds_utilized_all_b b
5835: WHERE a.qp_list_header_id = b.plan_id
5836: AND b.utilization_id = p_util_id ;
5837:
5838: --nirprasa, added for bug 7030415.