APPS.AHL_DI_ASSO_DOC_GEN_PVT dependencies on AHL_DOC_TITLE_ASSOS_VL

Line 822: FROM AHL_DOC_TITLE_ASSOS_VL

818: c_figure VARCHAR2)
819:
820: IS
821: SELECT doc_title_asso_id
822: FROM AHL_DOC_TITLE_ASSOS_VL
823: WHERE aso_object_id = c_aso_object_id
824: AND aso_object_type_code = c_aso_object_type_code
825: AND document_id = c_document_id
826: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)

Line 850: FROM AHL_DOC_TITLE_ASSOS_VL

846: c_figure VARCHAR2)
847:
848: IS
849: SELECT doc_title_asso_id
850: FROM AHL_DOC_TITLE_ASSOS_VL
851: WHERE doc_title_asso_id <> c_doc_title_asso_id
852: AND aso_object_id = c_aso_object_id
853: AND aso_object_type_code = c_aso_object_type_code
854: AND document_id = c_document_id

Line 1457: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,

1453: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1454: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1455: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1456: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1457: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,
1458: x_return_status OUT NOCOPY VARCHAR2 ,
1459: x_msg_count OUT NOCOPY NUMBER ,
1460: x_msg_data OUT NOCOPY VARCHAR2)
1461: IS

Line 1477: FROM AHL_DOC_TITLE_ASSOS_VL

1473: c_figure VARCHAR2)
1474:
1475: IS
1476: SELECT doc_title_asso_id
1477: FROM AHL_DOC_TITLE_ASSOS_VL
1478: WHERE aso_object_id = c_aso_object_id
1479: AND aso_object_type_code = c_aso_object_type_code
1480: AND document_id = c_document_id
1481: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)

Line 1972: SELECT * FROM AHL_DOC_TITLE_ASSOS_VL

1968: -- Retrives all the records for passed aso object
1969: CURSOR get_assos_b_cur (c_object_id NUMBER,
1970: c_object_type_code VARCHAR2)
1971: IS
1972: SELECT * FROM AHL_DOC_TITLE_ASSOS_VL
1973: WHERE ASO_OBJECT_ID = c_object_id
1974: AND ASO_OBJECT_TYPE_CODE = c_object_type_code;
1975: --
1976: l_api_name CONSTANT VARCHAR2(30) := 'COPY_ASSOCIATION';