APPS.OZF_ACTBUDGETS_PVT dependencies on OZF_OFFERS

Line 340: FROM ozf_offers

336: l_act_bud_cst_msg VARCHAR2(4000);
337:
338: CURSOR c_offer_info(p_object_id IN NUMBER) IS
339: SELECT custom_setup_id
340: FROM ozf_offers
341: WHERE qp_list_header_id = p_object_id;
342:
343: CURSOR c_act_budget_id IS
344: SELECT ozf_act_budgets_s.NEXTVAL

Line 1416: FROM ozf_offers

1412:
1413: --feliu
1414: /* CURSOR c_offer_status IS
1415: SELECT status_code
1416: FROM ozf_offers
1417: WHERE qp_list_header_id = p_act_budgets_rec.act_budget_used_by_id;
1418: fix bug 3116943 by feliu 08/28/03
1419: */
1420: CURSOR c_offer_status(l_qp_header_id IN NUMBER) IS

Line 1422: FROM ozf_offers

1418: fix bug 3116943 by feliu 08/28/03
1419: */
1420: CURSOR c_offer_status(l_qp_header_id IN NUMBER) IS
1421: SELECT status_code
1422: FROM ozf_offers
1423: WHERE qp_list_header_id = l_qp_header_id;
1424:
1425: -- yzhao: R12 insert/update ozf_object_fund_summary table
1426: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS

Line 3356: FROM ozf_offers

3352:
3353: -- sangara - Bug - 4553660
3354: CURSOR c_get_offer_info(l_qp_list_header_id IN NUMBER) IS
3355: SELECT offer_type, org_id
3356: FROM ozf_offers
3357: WHERE qp_list_header_id = l_qp_list_header_id;
3358:
3359: l_offerType VARCHAR2(30);
3360: l_offerOrgId NUMBER;

Line 4136: FROM ozf_offers

4132: WHERE fund_id = p_source_fund_id;
4133:
4134: CURSOR c_offer_info(p_object_id IN NUMBER) IS
4135: SELECT custom_setup_id
4136: FROM ozf_offers
4137: WHERE qp_list_header_id = p_object_id;
4138:
4139: BEGIN
4140: -- fund to fund approval

Line 4411: FROM ozf_offers

4407: WHERE fund_id = p_object_id;
4408:
4409: CURSOR c_offer IS
4410: SELECT nvl(transaction_currency_code, fund_request_curr_code)
4411: FROM ozf_offers
4412: WHERE qp_list_header_id = p_object_id;
4413:
4414: CURSOR c_pricelist IS
4415: SELECT currency_code