APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 1134: FROM AHL_DOC_TITLE_ASSOS_B

1130: FND_MSG_PUB.ADD;
1131: END IF;
1132:
1133: SELECT COUNT(*) INTO l_counter
1134: FROM AHL_DOC_TITLE_ASSOS_B
1135: WHERE ASO_OBJECT_ID=p_mr_header_rec.MR_HEADER_ID
1136: AND ASO_OBJECT_TYPE_CODE='MR';
1137:
1138: IF l_counter >0

Line 2710: Select * from AHL_DOC_TITLE_ASSOS_B

2706: Where mr_effectivity_id=c_mr_effectivity_id;
2707:
2708: Cursor curGetMrdocAssociations(c_mr_header_id number)
2709: Is
2710: Select * from AHL_DOC_TITLE_ASSOS_B
2711: Where ASO_OBJECT_ID=C_MR_HEADER_ID
2712: And ASO_OBJECT_TYPE_CODE='MR';
2713: l_mr_doc_rec curGetMrdocAssociations%rowtype;
2714:

Line 2831: Delete from AHL_DOC_TITLE_ASSOS_B

2827: Then
2828: Delete from AHL_DOC_TITLE_ASSOS_TL
2829: Where DOC_TITLE_ASSO_ID = l_mr_doc_rec.DOC_TITLE_ASSO_ID;
2830:
2831: Delete from AHL_DOC_TITLE_ASSOS_B
2832: Where DOC_TITLE_ASSO_ID = l_mr_doc_rec.DOC_TITLE_ASSO_ID;
2833: Elsif curGetMrdocAssociations%NotFound
2834: Then
2835: Exit;