APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 949: FROM AHL_MR_RELATIONSHIPS

945:
946: IF p_mr_header_rec.TYPE_CODE<>l_mr_rec.type_code
947: THEN
948: SELECT COUNT(*) INTO l_counter
949: FROM AHL_MR_RELATIONSHIPS
950: WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID;
951: IF l_counter >0
952: THEN
953: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_REL_SHOULDNOT_EXIST');

Line 2469: Delete AHL_MR_RELATIONSHIPS

2465: End if;
2466: End loop;
2467: Close curGetMrdocAssociations;
2468:
2469: Delete AHL_MR_RELATIONSHIPS
2470: Where mr_header_id=p_mr_header_id
2471: or RELATED_MR_HEADER_ID=P_MR_HEADER_ID;
2472:
2473: l_msg_count := FND_MSG_PUB.count_msg;