APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_FUNDS_ALL_B

Line 47: FROM ozf_funds_all_b

43: l_org_id number := NULL;
44:
45: CURSOR get_fund_org_csr(p_id in number) IS
46: SELECT org_id
47: FROM ozf_funds_all_b
48: WHERE fund_id = p_actbudget_id;
49:
50: BEGIN
51:

Line 694: FROM ozf_funds_all_b

690:
691: CURSOR c_funds (p_ofr_fund_id IN NUMBER) IS
692: SELECT fund_type
693: ,accrual_basis,plan_id
694: FROM ozf_funds_all_b
695: WHERE fund_id = p_ofr_fund_id;
696: -- 6/13/2002 mpande added for deal type ofer
697: CURSOR c_accrual_flag (p_price_adjustment_id IN NUMBER) IS
698: SELECT NVL(accrual_flag,'N')

Line 705: FROM ozf_funds_all_b

701:
702: -- 07/30/03 feliu added for accrual budget.
703: CURSOR c_fund_plan (p_plan_id IN NUMBER) IS
704: SELECT fund_id , currency_code_tc, accrual_basis
705: FROM ozf_funds_all_b
706: WHERE plan_id = p_plan_id;
707:
708: -- 18-JAN-05 kdass get the cust_account_id from cust_acct_site_id
709: -- rimehrot for R12, added bill_to_site_use_id

Line 2933: FROM ozf_funds_all_b

2929: CURSOR c_budget_data(p_fund_id IN NUMBER) IS
2930: SELECT (NVL(original_budget, 0) - NVL(holdback_amt, 0)
2931: + NVL(transfered_in_amt, 0) - NVL(transfered_out_amt, 0)) available_budget,
2932: fund_id,currency_code_tc
2933: FROM ozf_funds_all_b
2934: WHERE fund_id = p_fund_id;
2935:
2936:
2937: --get un_utilized budget.