APPS.JTF_MSITE_GRP dependencies on JTF_STORES_B

Line 20: jtf_stores_b b

16: CURSOR valid_store_msite_cur(p_msite_id IN NUMBER) IS
17: select 1 from dual where exists (
18: select msite_id
19: from jtf_msites_b a ,
20: jtf_stores_b b
21: WHERE a.msite_id = p_msite_id
22: and b.store_id = a.store_id );
23: l_exists NUMBER;
24: l_return_status Boolean := false;

Line 350: select store_id from jtf_stores_b

346: SELECT jtf_msites_b_s1.NEXTVAL
347: FROM DUAL;
348:
349: CURSOR store_id_cur IS
350: select store_id from jtf_stores_b
351: where rownum < 2 ;
352:
353: CURSOR master_msite_any_cur IS
354: select 1 from dual where exists (