APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on AHL_DOC_TITLE_ASSOS_VL

Line 497: FROM AHL_DOC_TITLE_ASSOS_VL

493: c_figure VARCHAR2)
494:
495: IS
496: SELECT 'X'
497: FROM AHL_DOC_TITLE_ASSOS_VL
498: WHERE aso_object_id = c_aso_object_id
499: AND aso_object_type_code = c_aso_object_type_code
500: AND document_id = c_document_id
501: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)

Line 1077: FROM AHL_DOC_TITLE_ASSOS_VL

1073: c_figure VARCHAR2)
1074:
1075: IS
1076: SELECT doc_title_asso_id
1077: FROM AHL_DOC_TITLE_ASSOS_VL
1078: WHERE doc_title_asso_id <> c_doc_title_asso_id
1079: AND aso_object_id = c_aso_object_id
1080: AND aso_object_type_code = c_aso_object_type_code
1081: AND document_id = c_document_id

Line 1594: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,

1590: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1591: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1592: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1593: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1594: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,
1595: x_return_status OUT NOCOPY VARCHAR2 ,
1596: x_msg_count OUT NOCOPY NUMBER ,
1597: x_msg_data OUT NOCOPY VARCHAR2)
1598: IS

Line 2045: SELECT * FROM AHL_DOC_TITLE_ASSOS_VL

2041: -- Retrives all the records for passed aso object
2042: CURSOR get_assos_b_cur (c_object_id NUMBER,
2043: c_object_type_code VARCHAR2)
2044: IS
2045: SELECT * FROM AHL_DOC_TITLE_ASSOS_VL
2046: WHERE ASO_OBJECT_ID = c_object_id
2047: AND ASO_OBJECT_TYPE_CODE = c_object_type_code;
2048: --
2049: l_api_name CONSTANT VARCHAR2(30) := 'COPY_ASSOCIATION';