APPS.OZF_FUND_APPROVAL_PVT dependencies on OZF_FUNDS_ALL_B

Line 52: from ozf_funds_all_b

48: l_org_id number;
49:
50: cursor get_fund_org_csr(p_id in number) is
51: select org_id
52: from ozf_funds_all_b
53: where fund_id = p_id;
54:
55: begin
56:

Line 119: from ozf_funds_all_b b ,

115: --asylvia 11-May-2006 bug 5199719 - SQL ID 17778754
116: CURSOR c_fund_rec (p_fund_id IN NUMBER) IS
117: select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
118: b.fund_type
119: from ozf_funds_all_b b ,
120: ozf_funds_all_tl t ,
121: jtf_rs_resource_extns_tl res
122: where b.fund_id = p_fund_id
123: and b.fund_id = t.fund_id

Line 330: from ozf_funds_all_b b ,

326: --asylvia 11-May-2006 bug 5199719 - SQL ID 17778783
327: CURSOR c_fund_rec (p_fund_id IN NUMBER) IS
328: select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
329: b.fund_type
330: from ozf_funds_all_b b ,
331: ozf_funds_all_tl t ,
332: jtf_rs_resource_extns_tl res
333: where b.fund_id = p_fund_id
334: and b.fund_id = t.fund_id

Line 753: from ozf_funds_all_b b ,

749: --asylvia 11-May-2006 bug 5199719 - SQL ID 17778839
750: CURSOR c_fund_rec (p_fund_id IN NUMBER) IS
751: select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
752: b.fund_type
753: from ozf_funds_all_b b ,
754: ozf_funds_all_tl t ,
755: jtf_rs_resource_extns_tl res
756: where b.fund_id = p_fund_id
757: and b.fund_id = t.fund_id

Line 1569: SELECT fund_type from ozf_funds_all_b where fund_id = l_fund_id;

1565: l_security_group_id NUMBER;
1566: l_fund_type VARCHAR2(30);
1567: l_org_id NUMBER;
1568: CURSOR c_get_fund_type IS
1569: SELECT fund_type from ozf_funds_all_b where fund_id = l_fund_id;
1570: BEGIN
1571: SAVEPOINT update_parbudget_status ;
1572: IF funcmode = 'RUN' THEN
1573: l_update_status :=

Line 2023: FROM ozf_funds_all_b ozf2, ozf_funds_all_b ozf1

2019: x_return_status OUT NOCOPY VARCHAR2
2020: ) IS
2021: CURSOR c_parent_fund_owner (p_fund_id IN NUMBER) IS
2022: SELECT ozf2.owner, ozf1.owner
2023: FROM ozf_funds_all_b ozf2, ozf_funds_all_b ozf1
2024: WHERE ozf2.fund_id = ozf1.parent_fund_id
2025: AND ozf1.fund_id = p_fund_id;
2026: l_fund_id NUMBER;
2027: l_fund_owner_id NUMBER;