APPS.JTF_MINISITERUNTIME_PVT dependencies on JTF_MSITE_PRTY_ACCSS

Line 237: From jtf_msite_prty_accss accss

233: ORDER BY respb.msite_resp_id;
234:
235: -- added to cache the minisite party access information -- ssridhar
236: Open x_party_access_cur FOR Select Party_id
237: From jtf_msite_prty_accss accss
238: Where accss.msite_id = l_msite_id
239: And sysdate Between accss.start_date_Active
240: And NVL(accss.end_date_active,sysdate);
241:

Line 494: -- Mini-site and party association (from jtf_msite_prty_accss table)

490: || 'sysdate BETWEEN MRB.start_date_active AND NVL(MRB.end_date_active,sysdate) AND '
491: || l_tmp_str
492: || 'ORDER BY MM.msite_id, MRB.msite_resp_id';
493:
494: -- Mini-site and party association (from jtf_msite_prty_accss table)
495: OPEN x_party_access_cur FOR 'SELECT MM.msite_id, party_id '
496: || 'FROM jtf_msite_prty_accss MP, jtf_msites_b MM WHERE '
497: || 'MM.msite_id = MP.msite_id AND '
498: || 'sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate) AND '

Line 496: || 'FROM jtf_msite_prty_accss MP, jtf_msites_b MM WHERE '

492: || 'ORDER BY MM.msite_id, MRB.msite_resp_id';
493:
494: -- Mini-site and party association (from jtf_msite_prty_accss table)
495: OPEN x_party_access_cur FOR 'SELECT MM.msite_id, party_id '
496: || 'FROM jtf_msite_prty_accss MP, jtf_msites_b MM WHERE '
497: || 'MM.msite_id = MP.msite_id AND '
498: || 'sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate) AND '
499: || l_tmp_str
500: || 'ORDER BY MM.msite_id';