APPS.OZF_FUND_APPROVAL_PVT dependencies on OZF_FUNDS_ALL_B

Line 83: from ozf_funds_all_b b ,

79: --asylvia 11-May-2006 bug 5199719 - SQL ID 17778754
80: CURSOR c_fund_rec (p_fund_id IN NUMBER) IS
81: select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
82: b.fund_type
83: from ozf_funds_all_b b ,
84: ozf_funds_all_tl t ,
85: jtf_rs_resource_extns_tl res
86: where b.fund_id = p_fund_id
87: and b.fund_id = t.fund_id

Line 294: from ozf_funds_all_b b ,

290: --asylvia 11-May-2006 bug 5199719 - SQL ID 17778783
291: CURSOR c_fund_rec (p_fund_id IN NUMBER) IS
292: select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
293: b.fund_type
294: from ozf_funds_all_b b ,
295: ozf_funds_all_tl t ,
296: jtf_rs_resource_extns_tl res
297: where b.fund_id = p_fund_id
298: and b.fund_id = t.fund_id

Line 717: from ozf_funds_all_b b ,

713: --asylvia 11-May-2006 bug 5199719 - SQL ID 17778839
714: CURSOR c_fund_rec (p_fund_id IN NUMBER) IS
715: select b.fund_number , t.short_name , b.currency_code_tc , b.start_date_active , res.RESOURCE_NAME ,
716: b.fund_type
717: from ozf_funds_all_b b ,
718: ozf_funds_all_tl t ,
719: jtf_rs_resource_extns_tl res
720: where b.fund_id = p_fund_id
721: and b.fund_id = t.fund_id

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

1528: l_appl_id NUMBER;
1529: l_security_group_id NUMBER;
1530: l_fund_type VARCHAR2(30);
1531: CURSOR c_get_fund_type IS
1532: SELECT fund_type from ozf_funds_all_b where fund_id = l_fund_id;
1533: BEGIN
1534: SAVEPOINT update_parbudget_status ;
1535: IF funcmode = 'RUN' THEN
1536: l_update_status :=

Line 1917: FROM ozf_funds_all_b ozf2, ozf_funds_all_b ozf1

1913: x_return_status OUT NOCOPY VARCHAR2
1914: ) IS
1915: CURSOR c_parent_fund_owner (p_fund_id IN NUMBER) IS
1916: SELECT ozf2.owner, ozf1.owner
1917: FROM ozf_funds_all_b ozf2, ozf_funds_all_b ozf1
1918: WHERE ozf2.fund_id = ozf1.parent_fund_id
1919: AND ozf1.fund_id = p_fund_id;
1920: l_fund_id NUMBER;
1921: l_fund_owner_id NUMBER;