DBA Data[Home] [Help]

APPS.AHL_RM_OPERATION_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 1725: FROM ahl_doc_title_assos_b

1721:
1722: CURSOR get_doc_associations( c_OPERATION_id NUMBER )
1723: IS
1724: SELECT doc_title_asso_id
1725: FROM ahl_doc_title_assos_b
1726: WHERE aso_object_id = c_OPERATION_id
1727: AND aso_object_type_code = 'OPERATION';
1728:
1729: cursor validate_oper_ovn

Line 2490: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL

2486: END LOOP;
2487:
2488: -- 3.Copy Reference Documents
2489: FOR I in get_doc_associations( p_operation_id ) LOOP
2490: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
2491: INTO l_doc_title_assos_id
2492: FROM DUAL;
2493:
2494: AHL_DOC_TITLE_ASSOS_PKG.insert_row