APPS.AHL_DI_DOC_INDEX_PUB dependencies on AHL_SUBSCRIPTIONS_B

Line 1342: FROM ahl_subscriptions_b

1338: -- adharia -- added nvl to end_date;--11 July 2002
1339: CURSOR check_sub_exists(c_document_id NUMBER)
1340: IS
1341: SELECT 'X'
1342: FROM ahl_subscriptions_b
1343: WHERE document_id = c_document_id
1344: AND NVL(end_date, sysdate) >= TRUNC(sysdate);
1345: --Added pjha for Restricting Subscription Avail to 'Yes' If supplier or subscription
1346: --Exists for the doc: End

Line 1369: FROM AHL_SUBSCRIPTIONS_B

1365: --pbarman : 28th July 2003
1366: CURSOR for_subcr_validate(c_supplier_id NUMBER, c_doc_id NUMBER)
1367: IS
1368: SELECT subscription_id
1369: FROM AHL_SUBSCRIPTIONS_B
1370: WHERE SUBSCRIBED_FRM_PARTY_ID = c_supplier_id
1371: AND DOCUMENT_ID = c_doc_id;
1372:
1373: -- Bug : Perf Fixes for 4918997