APPS.IBE_MINISITERUNTIME_PVT dependencies on IBY_CREDITCARD_ISSUERS_B

Line 594: FROM ibe_msite_information a, iby_creditcard_issuers_b cc

590: AND b.language=userenv('lang')
591: UNION
592: SELECT msite_information_context, msite_information1,
593: msite_information2
594: FROM ibe_msite_information a, iby_creditcard_issuers_b cc
595: WHERE a.msite_id = l_msite_id
596: AND a.msite_information1 = cc.card_issuer_code
597: ORDER BY msite_information_context;
598:

Line 1128: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci

1124: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
1125: FROM(select distinct to_number(t.column_value) as msite_id
1126: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1127: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1128: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci
1129: WHERE MM.msite_id = MI.msite_id
1130: AND MM.msite_id = v.msite_id
1131: AND MM.site_type = 'I'
1132: AND (MI.msite_information1 = cci.CARD_ISSUER_CODE)