APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_OFFERS

Line 688: FROM ozf_offers

684: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
685: SELECT offer_type
686: ,qualifier_id,qualifier_type,NVL(budget_offer_yn,'N'),beneficiary_account_id,
687: autopay_party_attr,autopay_party_id
688: FROM ozf_offers
689: WHERE qp_list_header_id = p_offer_id;
690:
691: CURSOR c_funds (p_ofr_fund_id IN NUMBER) IS
692: SELECT fund_type

Line 1361: FROM ozf_offers

1357: ,object_version_number
1358: ,distribution_type
1359: ,qp_list_header_id
1360: ,offer_id
1361: FROM ozf_offers
1362: WHERE qp_list_header_id = p_qp_list_header_id;
1363:
1364: l_lumpsum_offer cur_get_lumpsum_details%ROWTYPE;
1365:

Line 1833: FROM qp_list_headers_b qp,ozf_offers ofs

1829: CURSOR c_offer_date IS
1830: SELECT qp.start_date_active, NVL(qp.currency_code, ofs.fund_request_curr_code) currency_code,
1831: NVL(ofs.account_closed_flag,'N'),ofs.qualifier_id, ofs.qualifier_type,ofs.owner_id,ofs.custom_setup_id,
1832: ofs.org_id
1833: FROM qp_list_headers_b qp,ozf_offers ofs
1834: WHERE qp.list_header_id = p_offer_id
1835: AND qp.list_header_id = ofs.qp_list_header_id;
1836:
1837: --get product information.

Line 2253: FROM qp_list_headers_b qp,ozf_offers ofs

2249: CURSOR c_offer_date IS
2250: SELECT qp.start_date_active,qp.end_date_active, NVL(qp.currency_code, ofs.fund_request_curr_code) currency_code,
2251: ofs.custom_setup_id,NVL(ofs.account_closed_flag,'N'),ofs.qualifier_id, ofs.qualifier_type,
2252: ofs.org_id
2253: FROM qp_list_headers_b qp,ozf_offers ofs
2254: WHERE qp.list_header_id = p_offer_id
2255: AND qp.list_header_id = ofs.qp_list_header_id;
2256:
2257: ---get distribution

Line 2261: FROM ozf_offers

2257: ---get distribution
2258: CURSOR c_offer_distribution IS
2259: SELECT offer_amount
2260: ,distribution_type,owner_id
2261: FROM ozf_offers
2262: WHERE qp_list_header_id = p_offer_id;
2263:
2264: --get product information.
2265: CURSOR c_off_products (p_offer_id IN NUMBER) IS

Line 2699: FROM ozf_offers

2695:
2696: l_cust_setup NUMBER;
2697: CURSOR c_offer_rec(p_offer_id IN NUMBER) IS
2698: SELECT custom_setup_id
2699: FROM ozf_offers
2700: WHERE qp_list_header_id = p_offer_id;
2701:
2702: BEGIN
2703: SAVEPOINT post_utilized_budget;

Line 2896: FROM ozf_offers

2892:
2893: --get offer currency and source_from_parent
2894: CURSOR c_offer_data(p_qp_list_header_id IN NUMBER) IS
2895: SELECT nvl(transaction_currency_code,fund_request_curr_code),NVL(source_from_parent,'N'),qualifier_id
2896: FROM ozf_offers
2897: WHERE qp_list_header_id = p_qp_list_header_id;
2898:
2899: --get total committed remaining.
2900: ---Ribha commented this. Dont use ozf_object_checkbook_v (non mergeable view)

Line 3438: FROM ozf_request_headers_all_b req, ozf_offers off

3434: l_offer_org_id NUMBER;
3435: --get request date and currency.
3436: CURSOR c_request_date(p_offer_id IN NUMBER) IS
3437: SELECT req.request_header_id, req.currency_code,off.qualifier_id, req.submitted_by,off.org_id --approved_by
3438: FROM ozf_request_headers_all_b req, ozf_offers off
3439: WHERE req.offer_id =p_offer_id
3440: AND req.offer_id = off.qp_list_header_id;
3441:
3442: --get expense information.