APPS.AHL_RM_ROUTE_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 2859: FROM ahl_doc_title_assos_b

2855:
2856: CURSOR get_doc_associations( c_route_id NUMBER )
2857: IS
2858: SELECT doc_title_asso_id
2859: FROM ahl_doc_title_assos_b
2860: WHERE aso_object_id = c_route_id
2861: AND aso_object_type_code = 'ROUTE';
2862:
2863: cursor validate_route_ovn

Line 4004: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL

4000: END LOOP;
4001:
4002: -- 3.Copy Reference Documents
4003: FOR I in get_doc_associations( p_route_id ) LOOP
4004: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
4005: INTO l_doc_title_assos_id
4006: FROM DUAL;
4007: -- pekambar changes for bug # 9342005 -- start
4008: -- Passing wrong values to attribute1 to attribute15 are corrected