APPS.OZF_FUND_APPROVAL_PVT dependencies on OZF_FUNDS_ALL_TL

Line 84: ozf_funds_all_tl t ,

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
88: and res.resource_id = b.owner

Line 295: ozf_funds_all_tl t ,

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
299: and res.resource_id = b.owner

Line 718: ozf_funds_all_tl t ,

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
722: and res.resource_id = b.owner