APPS.IBE_MINISITERUNTIME_PVT dependencies on IBY_CREDITCARD_ISSUERS_B

Line 329: FROM ibe_msite_information a, iby_creditcard_issuers_b cc

325: AND b.language=userenv('lang')
326: UNION
327: SELECT msite_information_context, msite_information1,
328: msite_information2
329: FROM ibe_msite_information a, iby_creditcard_issuers_b cc
330: WHERE a.msite_id = l_msite_id
331: AND a.msite_information1 = cc.card_issuer_code
332: ORDER BY msite_information_context;
333:

Line 863: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci

859: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
860: FROM(select distinct to_number(t.column_value) as msite_id
861: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
862: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
863: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci
864: WHERE MM.msite_id = MI.msite_id
865: AND MM.msite_id = v.msite_id
866: AND MM.site_type = 'I'
867: AND (MI.msite_information1 = cci.CARD_ISSUER_CODE)