APPS.AHL_DI_DOC_INDEX_PVT dependencies on AHL_SUBSCRIPTIONS_B

Line 2000: FROM AHL_SUBSCRIPTIONS_B

1996: CURSOR get_subc_rec(c_supplier_id NUMBER,
1997: c_document_id NUMBER)
1998: IS
1999: SELECT 'X'
2000: FROM AHL_SUBSCRIPTIONS_B
2001: WHERE document_id = c_document_id
2002: --AND subscribed_frm_party_id = c_supplier_id;
2003: AND subscribed_frm_party_id = c_supplier_id
2004: AND NVL(end_date,sysdate) >= TRUNC(sysdate);