APPS.AHL_DI_DOC_INDEX_PVT dependencies on AHL_SUBSCRIPTIONS_B

Line 2086: FROM AHL_SUBSCRIPTIONS_B

2082: CURSOR get_subc_rec(c_supplier_id NUMBER,
2083: c_document_id NUMBER)
2084: IS
2085: SELECT 'X'
2086: FROM AHL_SUBSCRIPTIONS_B
2087: WHERE document_id = c_document_id
2088: --AND subscribed_frm_party_id = c_supplier_id;
2089: AND subscribed_frm_party_id = c_supplier_id
2090: AND NVL(end_date,sysdate) >= TRUNC(sysdate);