APPS.OZF_FUND_APPROVAL_PVT dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 85: jtf_rs_resource_extns_tl res

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
89: and userenv ( 'LANG' ) = t.language

Line 296: jtf_rs_resource_extns_tl res

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
300: and userenv ( 'LANG' ) = t.language

Line 719: jtf_rs_resource_extns_tl res

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
723: and userenv ( 'LANG' ) = t.language