APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_FUNDS_ALL_B

Line 182: FROM ozf_funds_all_b

178: WHERE qp_list_header_id = p_src_id;
179: -- cursor for accrual fund
180: CURSOR c_fund IS
181: SELECT fund_id , currency_code_tc
182: FROM ozf_funds_all_b
183: WHERE plan_id = p_src_id;
184:
185: /* yzhao: 10/03/2003 fix bug 3156515 - PROMOTIONAL GOODS OFFER EXCEEDS THE BUDGET AMOUNT
186: get utilized amount.

Line 795: FROM ozf_funds_all_b

791: ,NVL(liability_flag, 'N')
792: -- yzhao: 11.5.10
793: ,utilized_amt
794: ,rollup_utilized_amt
795: FROM ozf_funds_all_b
796: WHERE fund_id = p_fund_id;
797:
798: /* R12: yzhao bug 4669269 - obsolete ozf_mc_transactions
799: CURSOR c_mc_trans(p_fund_id IN NUMBER) IS

Line 834: FROM ozf_funds_all_b

830: ,rollup_committed_amt
831: ,rollup_recal_committed
832: -- yzhao: 11.5.10
833: ,rollup_utilized_amt
834: FROM ozf_funds_all_b
835: connect by prior parent_fund_id =fund_id
836: start with fund_id = p_fund_id;
837:
838: /* 10/14/2003 yzhao Fix TEVA bug - customer fully accrual budget committed amount is always 0

Line 888: ,ozf_funds_all_b fun

884: -- yzhao: 11.5.10 check if post to gl for off invoice discount
885: CURSOR c_fund_sob(p_fund_id IN NUMBER) IS
886: SELECT sob.set_of_books_id, fun.ORG_id, NVL(sob.gl_acct_for_offinv_flag, 'F')
887: FROM ozf_sys_parameters_all sob
888: ,ozf_funds_all_b fun
889: WHERE fun.fund_id = p_fund_id
890: AND sob.org_id = fun.ORG_id ;
891: */
892:

Line 896: ,ozf_funds_all_b fun

892:
893: CURSOR c_fund_ledger(p_fund_id IN NUMBER) IS
894: SELECT fun.ledger_id
895: FROM ozf_sys_parameters_all sob
896: ,ozf_funds_all_b fun
897: WHERE fun.fund_id = p_fund_id
898: AND sob.org_id = fun.org_id;
899:
900: CURSOR c_offinv_flag(p_org_id IN NUMBER) IS

Line 1648: UPDATE ozf_funds_all_b

1644: -- end R12 changes
1645: END IF; */
1646: END IF; -- end of fund_type.
1647:
1648: UPDATE ozf_funds_all_b
1649: SET original_budget = l_original_budget,
1650: utilized_amt = l_utilized_amt,
1651: earned_amt = l_earned_amt,
1652: paid_amt = l_paid_amt,

Line 1669: UPDATE ozf_funds_all_b

1665:
1666: IF l_parent_fund_id is NOT NULL THEN
1667: FOR fund IN c_parent(l_parent_fund_id)
1668: LOOP
1669: UPDATE ozf_funds_all_b
1670: SET object_version_number = fund.object_version_number + 1
1671: ,rollup_original_budget = NVL(fund.rollup_original_budget,0) + NVL(l_new_orig_amt,0)
1672: ,rollup_earned_amt = NVL(fund.rollup_earned_amt,0) + NVL(l_new_earned_amt,0)
1673: ,rollup_paid_amt = NVL(fund.rollup_paid_amt,0) + NVL(l_new_paid_amt,0)

Line 4608: FROM ozf_funds_all_b

4604: WHERE org_id = p_org_id;
4605:
4606: CURSOR c_get_fund (p_fund_id IN NUMBER) IS
4607: SELECT object_version_number, parent_fund_id, currency_code_tc,liability_flag,accrual_basis
4608: FROM ozf_funds_all_b
4609: WHERE fund_id = p_fund_id;
4610:
4611: /* R12: yzhao bug 4669269 - obsolete ozf_mc_transactions
4612: CURSOR c_mc_trans(p_fund_id IN NUMBER) IS

Line 4623: FROM ozf_funds_all_b

4619:
4620: CURSOR c_parent (p_fund_id IN NUMBER)IS
4621: SELECT fund_id
4622: ,object_version_number
4623: FROM ozf_funds_all_b
4624: connect by prior parent_fund_id =fund_id
4625: start with fund_id = p_fund_id;
4626:
4627: -- rimehrot: for R12 update ozf_object_fund_summary table

Line 4855: UPDATE ozf_funds_all_b

4851: -- end R12 changes
4852:
4853: END IF; -- p_util_utilization_type = 'SALES_ACCRUAL'
4854:
4855: UPDATE ozf_funds_all_b
4856: SET original_budget = NVL(original_budget, 0) + NVL(l_orig_amt, 0)
4857: ,rollup_original_budget = NVL(rollup_original_budget, 0) + NVL(l_rollup_orig_amt, 0)
4858: ,earned_amt = NVL(earned_amt, 0) + NVL(l_earned_amt, 0)
4859: ,paid_amt = NVL(paid_amt, 0 ) + NVL(l_paid_amt, 0)

Line 4869: UPDATE ozf_funds_all_b

4865:
4866: IF l_parent_fund_id is NOT NULL THEN
4867: FOR fund IN c_parent(l_parent_fund_id)
4868: LOOP
4869: UPDATE ozf_funds_all_b
4870: SET object_version_number = fund.object_version_number + 1
4871: ,rollup_earned_amt = NVL(rollup_earned_amt,0) + NVL(l_new_univ_amt,0)
4872: ,rollup_paid_amt = NVL(rollup_paid_amt,0) + NVL(l_rollup_paid_amt,0)
4873: ,rollup_original_budget = NVL(rollup_original_budget,0) + NVL(l_rollup_orig_amt,0)