APPS.AMS_RUNTIME_PROD_PVT dependencies on JTF_DSP_SECTION_ITEMS

Line 64: SELECT COUNT(B.SECTION_ITEM_ID) INTO rowsReturned FROM JTF_DSP_SECTION_ITEMS s, JTF_DSP_MSITE_SCT_ITEMS b

60: FUNCTION isBelongToMinisite(p_item_id IN NUMBER, p_msite_id IN NUMBER) RETURN BOOLEAN
61: IS
62: rowsReturned NUMBER :=0;
63: BEGIN
64: SELECT COUNT(B.SECTION_ITEM_ID) INTO rowsReturned FROM JTF_DSP_SECTION_ITEMS s, JTF_DSP_MSITE_SCT_ITEMS b
65: WHERE S.SECTION_ITEM_ID = B.SECTION_ITEM_ID AND B.MINI_SITE_ID = p_msite_id
66: AND S.INVENTORY_ITEM_ID = p_item_id
67: AND NVL(S.START_DATE_ACTIVE,SYSDATE) < SYSDATE
68: AND NVL(S.END_DATE_ACTIVE,SYSDATE) > SYSDATE;