APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_OFFERS

Line 819: FROM ozf_offers

815: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
816: SELECT offer_type
817: ,qualifier_id,qualifier_type,NVL(budget_offer_yn,'N'),beneficiary_account_id,
818: autopay_party_attr,autopay_party_id
819: FROM ozf_offers
820: WHERE qp_list_header_id = p_offer_id;
821:
822: CURSOR c_funds (p_ofr_fund_id IN NUMBER) IS
823: SELECT fund_type

Line 1578: FROM ozf_offers

1574: ,object_version_number
1575: ,distribution_type
1576: ,qp_list_header_id
1577: ,offer_id
1578: FROM ozf_offers
1579: WHERE qp_list_header_id = p_qp_list_header_id;
1580:
1581: l_lumpsum_offer cur_get_lumpsum_details%ROWTYPE;
1582:

Line 1798: FROM ozf_offers

1794: AND arc_act_budget_used_by = p_used_by_type
1795: AND transfer_type = 'UTILIZED';
1796: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
1797: SELECT nvl(transaction_currency_code,fund_request_curr_code) offer_currency_code
1798: FROM ozf_offers
1799: WHERE qp_list_header_id = p_offer_id;
1800: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
1801: SELECT exchange_rate_type
1802: FROM ozf_sys_parameters_all

Line 2355: FROM qp_list_headers_b qp,ozf_offers ofs

2351: CURSOR c_offer_date IS
2352: SELECT qp.start_date_active, NVL(qp.currency_code, ofs.fund_request_curr_code) currency_code,
2353: NVL(ofs.account_closed_flag,'N'),ofs.qualifier_id, ofs.qualifier_type,ofs.owner_id,ofs.custom_setup_id,
2354: ofs.org_id
2355: FROM qp_list_headers_b qp,ozf_offers ofs
2356: WHERE qp.list_header_id = p_offer_id
2357: AND qp.list_header_id = ofs.qp_list_header_id;
2358:
2359: --get product information.

Line 2781: FROM qp_list_headers_b qp,ozf_offers ofs

2777: CURSOR c_offer_date IS
2778: SELECT qp.start_date_active,qp.end_date_active, NVL(qp.currency_code, ofs.fund_request_curr_code) currency_code,
2779: ofs.custom_setup_id,NVL(ofs.account_closed_flag,'N'),ofs.qualifier_id, ofs.qualifier_type,
2780: ofs.org_id
2781: FROM qp_list_headers_b qp,ozf_offers ofs
2782: WHERE qp.list_header_id = p_offer_id
2783: AND qp.list_header_id = ofs.qp_list_header_id;
2784:
2785: ---get distribution

Line 2789: FROM ozf_offers

2785: ---get distribution
2786: CURSOR c_offer_distribution IS
2787: SELECT offer_amount
2788: ,distribution_type,owner_id
2789: FROM ozf_offers
2790: WHERE qp_list_header_id = p_offer_id;
2791:
2792: --get product information.
2793: CURSOR c_off_products (p_offer_id IN NUMBER) IS

Line 3374: FROM ozf_offers

3370:
3371: l_cust_setup NUMBER;
3372: CURSOR c_offer_rec(p_offer_id IN NUMBER) IS
3373: SELECT custom_setup_id
3374: FROM ozf_offers
3375: WHERE qp_list_header_id = p_offer_id;
3376:
3377: BEGIN
3378: SAVEPOINT post_utilized_budget;

Line 3571: FROM ozf_offers

3567:
3568: --get offer currency and source_from_parent
3569: CURSOR c_offer_data(p_qp_list_header_id IN NUMBER) IS
3570: SELECT nvl(transaction_currency_code,fund_request_curr_code),NVL(source_from_parent,'N'),qualifier_id
3571: FROM ozf_offers
3572: WHERE qp_list_header_id = p_qp_list_header_id;
3573:
3574: --get total committed remaining.
3575: ---Ribha commented this. Dont use ozf_object_checkbook_v (non mergeable view)

Line 4116: FROM ozf_request_headers_all_b req, ozf_offers off

4112: l_offer_org_id NUMBER;
4113: --get request date and currency.
4114: CURSOR c_request_date(p_offer_id IN NUMBER) IS
4115: SELECT req.request_header_id, req.currency_code,off.qualifier_id, req.submitted_by,off.org_id --approved_by
4116: FROM ozf_request_headers_all_b req, ozf_offers off
4117: WHERE req.offer_id =p_offer_id
4118: AND req.offer_id = off.qp_list_header_id;
4119:
4120: --get expense information.