APPS.OZF_ACTBUDGETS_PVT dependencies on OZF_OFFERS

Line 535: FROM ozf_offers

531: l_act_bud_cst_msg VARCHAR2(4000);
532:
533: CURSOR c_offer_info(p_object_id IN NUMBER) IS
534: SELECT custom_setup_id
535: FROM ozf_offers
536: WHERE qp_list_header_id = p_object_id;
537:
538: CURSOR c_act_budget_id IS
539: SELECT ozf_act_budgets_s.NEXTVAL

Line 1973: FROM ozf_offers

1969: l_transaction_currency VARCHAR2(15);
1970: --feliu
1971: /* CURSOR c_offer_status IS
1972: SELECT status_code
1973: FROM ozf_offers
1974: WHERE qp_list_header_id = p_act_budgets_rec.act_budget_used_by_id;
1975: fix bug 3116943 by feliu 08/28/03
1976: */
1977: CURSOR c_offer_status(l_qp_header_id IN NUMBER) IS

Line 1979: FROM ozf_offers

1975: fix bug 3116943 by feliu 08/28/03
1976: */
1977: CURSOR c_offer_status(l_qp_header_id IN NUMBER) IS
1978: SELECT status_code
1979: FROM ozf_offers
1980: WHERE qp_list_header_id = l_qp_header_id;
1981:
1982: -- yzhao: R12 insert/update ozf_object_fund_summary table
1983: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS

Line 4173: FROM ozf_offers

4169:
4170: -- sangara - Bug - 4553660
4171: CURSOR c_get_offer_info(l_qp_list_header_id IN NUMBER) IS
4172: SELECT offer_type, org_id
4173: FROM ozf_offers
4174: WHERE qp_list_header_id = l_qp_list_header_id;
4175:
4176: l_offerType VARCHAR2(30);
4177: l_offerOrgId NUMBER;

Line 4953: FROM ozf_offers

4949: WHERE fund_id = p_source_fund_id;
4950:
4951: CURSOR c_offer_info(p_object_id IN NUMBER) IS
4952: SELECT custom_setup_id
4953: FROM ozf_offers
4954: WHERE qp_list_header_id = p_object_id;
4955:
4956: BEGIN
4957: -- fund to fund approval

Line 5228: FROM ozf_offers

5224: WHERE fund_id = p_object_id;
5225:
5226: CURSOR c_offer IS
5227: SELECT nvl(transaction_currency_code, fund_request_curr_code)
5228: FROM ozf_offers
5229: WHERE qp_list_header_id = p_object_id;
5230:
5231: CURSOR c_pricelist IS
5232: SELECT currency_code