APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 1004: FROM AHL_DOC_TITLE_ASSOS_B

1000: FND_MSG_PUB.ADD;
1001: END IF;
1002:
1003: SELECT COUNT(*) INTO l_counter
1004: FROM AHL_DOC_TITLE_ASSOS_B
1005: WHERE ASO_OBJECT_ID=p_mr_header_rec.MR_HEADER_ID
1006: AND ASO_OBJECT_TYPE_CODE='MR';
1007:
1008: IF l_counter >0

Line 2366: Select * from AHL_DOC_TITLE_ASSOS_B

2362: Where mr_effectivity_id=c_mr_effectivity_id;
2363:
2364: Cursor curGetMrdocAssociations(c_mr_header_id number)
2365: Is
2366: Select * from AHL_DOC_TITLE_ASSOS_B
2367: Where ASO_OBJECT_ID=C_MR_HEADER_ID
2368: And ASO_OBJECT_TYPE_CODE='MR';
2369: l_mr_doc_rec curGetMrdocAssociations%rowtype;
2370:

Line 2460: Delete from AHL_DOC_TITLE_ASSOS_B

2456: Then
2457: Delete from AHL_DOC_TITLE_ASSOS_TL
2458: Where DOC_TITLE_ASSO_ID = l_mr_doc_rec.DOC_TITLE_ASSO_ID;
2459:
2460: Delete from AHL_DOC_TITLE_ASSOS_B
2461: Where DOC_TITLE_ASSO_ID = l_mr_doc_rec.DOC_TITLE_ASSO_ID;
2462: Elsif curGetMrdocAssociations%NotFound
2463: Then
2464: Exit;