DBA Data[Home] [Help]

APPS.OZF_FUND_APPROVAL_PVT dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 121: jtf_rs_resource_extns_tl res

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
124: and res.resource_id = b.owner
125: and userenv ( 'LANG' ) = t.language

Line 332: jtf_rs_resource_extns_tl res

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
335: and res.resource_id = b.owner
336: and userenv ( 'LANG' ) = t.language

Line 755: jtf_rs_resource_extns_tl res

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
758: and res.resource_id = b.owner
759: and userenv ( 'LANG' ) = t.language