APPS.AMS_RUNTIME_PROD_PVT dependencies on JTF_DSP_MSITE_SCT_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;