APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITE_PRTY_ACCSS

Line 305: From ibe_msite_prty_accss accss

301: ORDER BY respb.msite_resp_id;
302:
303: -- added to cache the minisite party access information -- ssridhar
304: Open x_party_access_cur FOR Select Party_id
305: From ibe_msite_prty_accss accss
306: Where accss.msite_id = l_msite_id
307: And sysdate Between accss.start_date_Active
308: And NVL(accss.end_date_active,sysdate);
309:

Line 817: -- Mini-site and party association (from ibe_msite_prty_accss table)

813: AND MM.msite_id = v.msite_id
814: AND MM.site_type = 'I'
815: ORDER BY MM.msite_id, MRB.msite_resp_id;
816:
817: -- Mini-site and party association (from ibe_msite_prty_accss table)
818: OPEN x_party_access_cur FOR SELECT /*+ ORDERED USE_NL (V MM MP) INDEX (MM,IBE_MSITES_B_U1) */
819: MM.msite_id, party_id
820: FROM (select distinct to_number(t.column_value) as msite_id
821: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

Line 823: ibe_msites_b MM, ibe_msite_prty_accss MP

819: MM.msite_id, party_id
820: FROM (select distinct to_number(t.column_value) as msite_id
821: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
822: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
823: ibe_msites_b MM, ibe_msite_prty_accss MP
824: WHERE MM.msite_id = MP.msite_id
825: AND sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate)
826: AND MM.msite_id = v.msite_id
827: AND MM.site_type = 'I'