APPS.AHL_RM_ROUTE_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 2540: FROM ahl_doc_title_assos_b

2536:
2537: CURSOR get_doc_associations( c_route_id NUMBER )
2538: IS
2539: SELECT doc_title_asso_id
2540: FROM ahl_doc_title_assos_b
2541: WHERE aso_object_id = c_route_id
2542: AND aso_object_type_code = 'ROUTE';
2543:
2544: cursor validate_route_ovn

Line 3580: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL

3576: END LOOP;
3577:
3578: -- 3.Copy Reference Documents
3579: FOR I in get_doc_associations( p_route_id ) LOOP
3580: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
3581: INTO l_doc_title_assos_id
3582: FROM DUAL;
3583:
3584: AHL_DOC_TITLE_ASSOS_PKG.insert_row